Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Address Recognition and Separation
Hello,
I have a large ammout of data that I'm attempting to sort by location however the source that I receive my data from sends it to me with the names and addresses all in one colum. I have been able to seperate, not effectivly, the names from the addresses using text to column but I need to be able to pull the city, state and zip into other columns without having to manually edit each of my 6,000 per month entries. Is there any thing I can use that will recognise the address and seperate it out... even if it is outside of Excel? Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date number separation | Excel Discussion (Misc queries) | |||
Cell Separation | Excel Worksheet Functions | |||
Letter and numeral separation | Excel Worksheet Functions | |||
Decimals separation "." and "," | Excel Worksheet Functions | |||
Decimals separation by . or , | Excel Discussion (Misc queries) |