I have a number addresses; each in a single cell. I need to extract the state code from each cell. Every address is formated exactly the same (i.e. the state code occurs before the last space of each address field). Examples are as follows:
55555 DON JUAN PLACE WOODLAND HILLS CA 91364-6554
55555 POINTE REGAL CIRCLE APT 4X4 DEL RAY BEACH FL 33484
12345 SOUTH LAKESHORE DR APT PH0 BROWNS MILLS NJ 08015-4300
55555 HASSOP LANE BURLESON TX 76028
Desired output as follows:
CA
FL
NJ
TX
Thanks in advance for any comments.
Bookmarks