Hi everyone,
I have some data like this in cells a1:a1000. What I need to do is to clean the data so that the grid reference is removed. The grid reference can be anything from the first 1 to the first 5 characters. The problem I have is getting it to recognise the number of characters so it knows how many to delete. Any ideas.
Z2 - Behind Cropston Ave
D20 - Barlestone Parish
C3b - Field between Barton Road and Poplar Terrace, Congerstone
B711 - Bird Field
C2 - Bodmin open space
C17 - Manor Road
Bookmarks