Converting State Names to State Abbreviations

[aznate]

I am trying to convert a column of full length state names to a column next
to it with the corresponding state abbreviation. I am a beginner so dumbing
down any suggestions would be appreciated. Thank you!!

 

[Biff]

Hi!

You'd need to create a 2 column table and then use a lookup formula.

In say, H1:H50 list the FULL state names. In I1:I50 list the abbreviation of
the corresponding state. Then:

Assume your list of full names is in A1:A10.
Enter this formula in B1 and copy down to B10:

=IF(A1="","",VLOOKUP(A1,H$1:I$50,2,0))

Biff