| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I manipulate a string to collect the address from it?
My string is in a notes column (exported file to excel) which includes a
variable length address separated by two distinct words (Address: and Description) which I would like to place into three new columns. For example, string in column is: "'ABC Ltd Address: John Farm Ringo Road Milton Keynes MK11 ABC Description: Band members Telephone: (01908) 111111 Facsimile: (01908) 222222 Web site www.abc.com So I would like to obtain the address as follows: Street City Post Code John Farm Milton Keynes MK11 ABC Ringo Road I would also like to split the other data into appropriate columns but I am more concerned with the address for now. Can anyone help please? I have tried Text to Columns but can't work out what the delimters are as the data is on separate lines as shown above, so no comma to use etc and space varies. Also tried MID starting at number of characters to Address: but don't know how to work backwards to Description. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find String in another string - only between spaces | Excel Worksheet Functions | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Extracting out of a emai address string | Excel Discussion (Misc queries) | |||
| Browse File for Mac | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
