Excel Formulas, help?

[sloppy]

<table border="0" cellpadding="0" cellspacing="0" width="162"><col style="width: 122pt;" width="162"> <tbody><tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt; width: 122pt;" width="162" height="21">Worcester, MA 01602</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Sacramento, CA 95814</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bloomington, IN 47401</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Indianapolis, IN 46201</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Kaneohe, HI 96744</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Worcester, MA 01602</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Bloomington, IN 47401
<table border="0" cellpadding="0" cellspacing="0" width="162"><col width="162"><tbody><tr height="20"> <td style="height: 15pt; width: 122pt;" width="162" height="20">Long Beach, CA 90745</td> </tr></tbody></table>

I have to use a function that will just show the state abbreviations, Example: MA I think you use the MID function but its hard for me to find a formula that will work for all of them, any ideas?
</td> </tr> </tbody></table>

 

[shg]

How about =right(a1, 2)

Or (if the zip is in the same cell),

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

 

[sloppy]

yes, the zipcode is all in the same column. The MID formula that you posted works, thanks so much!

 

[scottylad2]

If your Zips are always the same and the abreviations and space are always the same then this will work as well

Excel Workbook
	D	E
8	Worcester, MA 01602	MA
9	Sacramento, CA 95814	CA
10	Bloomington, IN 47401	IN
11	Indianapolis, IN 46201	IN
12	Kaneohe, HI 96744	HI
13	Worcester, MA 01602	MA
14	Bloomington, IN 47401	IN
15	Long Beach, CA 90745	CA
Sheet3

 

[texasaswang]

Thats a neat trick shg. I'm saving that one!