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 |
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 |
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 |
All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com