Extract characters from cell

[Juan Marin]

Good morning everyone,

I would really appreciate if somebody could give me a hand with this:
I'm trying to extract the state for each one of my cells on the row
labeled "Description", the data looks like this:

DESCRIPTION
Abbeville, LA Micropolitan Statistical Area
Aberdeen, SD Micropolitan Statistical Area
Aberdeen, WA Micropolitan Statistical Area
Abilene, TX Metropolitan Statistical Area
Ada, OK Micropolitan Statistical Area
Adrian, MI Micropolitan Statistical Area
Akron, OH Metropolitan Statistical Area
Alamogordo, NM Micropolitan Statistical Area
Albany, GA Metropolitan Statistical Area
Albany-Lebanon, OR Micropolitan Statistical Area
Albany-Schenectady-Troy, NY Metropolitan Statistical Area

Thank you!

JM

 

[Peo Sjoblom]

Assume the data is in column A starting in A1, in B1 put


=MID(A1,FIND(",",A1)+2,2)


press enter

Select B1 again, move the cursor to the lower right corner of B1 and when it
changes to a thick cross double click to copy down the formula.

While still selected press Ctrl + C, then do edit>paste special and select
values


Replace A1 with the cell address of the first cell with data



--


Regards,


Peo Sjoblom

 

[Pete_UK]

Assuming your data starts in A2, put this in B2:

=MID(A2,FIND(",",A2)+2,2)

and copy down as required.

Hope this helps.

Pete