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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Specific Text
mjmoore
First, search/replace comma with nothing Then, text to columns. Beege "mjmoore" wrote in message ... 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 -- mjmoore |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Specific Text
=MID(A1,FIND(",",A1,1)+2,2)
Vaya con Dios, Chuck, CABGx3 "mjmoore" wrote: 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 -- mjmoore |
Reply |
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) |