In another location, perhaps a second sheet (say, sheet2), enter the
abbreviations and states:

A B
1 AL Alabama
2 AK Alaska
3 ...

Then, assuming your abbreviation is entered in sheet1, cell D1, use
VLOOKUP:


=VLOOKUP(D1, Sheet2!A:B, 2, FALSE)


In article ,
julieb wrote:

I am entering an abbreviation of a state (along with a city name) in one cell
& needing it to spell out just the state name (fully) in a different cell
within the same excel workbook. How do I do this? Is there a program out
there that I can use? I need this to work on all the states.