Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract Specific Text
I have a mailing list that has a line in each address that looks like the examples below:
Anchorage, AK 99523-2416 Montville, NJ 07045-9601 San Francisco, CA 94110-5368 I would like to put the state abbreviation in the column next to it so I can sort by state. Ideally I wuld like to break out the city, state and zip. The state is the essential piece. Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning specific text only | Excel Worksheet Functions | |||
formula to extract partial content (text) of cell | Excel Discussion (Misc queries) | |||
Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |