Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parsing address info
I have address information obtained from a 3rd party. All information for a
particular adress is contained in a single cell with no delimiters between address1 address 2 suburb state and postal code. I can't use fixed width in text to columns as all components of the address are different character lengths. Anyone got any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I manipulate a string to collect the address from it? | Excel Discussion (Misc queries) | |||
how can i convert an email address to a web address | Excel Worksheet Functions | |||
Hyperlink Address and SubAddress not concatenating correctly | Excel Discussion (Misc queries) | |||
Formular to add to a IP address | Excel Discussion (Misc queries) | |||
MIN Function w/ variable address reference | Excel Worksheet Functions |