| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
split string based on a SET of words
hi,
i have a string containing an address/town/zip code and want to split them in seperate columns. example: 123 ocean rd smalltown 2134 into: 123 ocean rd | smalltown | 2134 i don't know to do the first split as its position varies but the street always ends with rd, st, ave. can that be of any help? can someone help me? regards mordy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting the last set of words from a text string | Excel Worksheet Functions | |||
| Split 2 words | Excel Worksheet Functions | |||
| Split sentences into words | Excel Discussion (Misc queries) | |||
| Split the words | Excel Discussion (Misc queries) | |||
| How do I split a cell of 2 words into two cells | Excel Worksheet Functions | |||
Threaded Mode
