Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Text from a field
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Text from a field
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 "Zuzeppeddu" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Rows based on a number in a field | Excel Worksheet Functions | |||
extracting field info from getpivotdata formula | Excel Programming | |||
Extracting data from rows where one field is blank | Excel Discussion (Misc queries) | |||
Extracting month from a date field | Excel Discussion (Misc queries) | |||
HELP!! Populate text in single XL field, or bulk copy text into 1 field | Excel Programming |