Extracting Text from a field

[Zuzeppeddu]

Hi

I want to extract Text only data from a column. A sample is as below:

14 Nicholls Point Park Grove
56 William Morley Close
9a Geere Road
40 William Morley Crt
5 Croydon Road
47a Liddington Road
11 Shiers Street

I want to extract all the text. So 47a Liddington Road would give me
'a Liddington Road'.

Any help would be very appreciated.

Thanks

 

[Guest]

You need a helper column.

Assuming your data are in column A1 down put this in B1 and drag down as
required

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

Will that do?

Mike