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