Mike H wrote:
There's a noce sorted list here

http://www.usps.com/ncsc/lookups/usp...eviations.html

They're the wrong way round for what you want but that's simply a matter of
manually reversing the columns. Then

=VLOOKUP("AZ",A1:B59,2,FALSE)

AZ could of coyrse be a cell reference

Mike
"gls858" wrote:

Does anyone have a way of converting state abbreviations to the full
state name? Example AZ to Arizona. I have two lists I need to sort by
state and compare. One list has the abbreviation and the other the full
name. Of course they don't sort the same.

gls858

Thanks Mike. I'll have to give it a try. Just got something else thrown
on my desk so it may be a while before I get back to the lists. I'll
try and post back to let you know if I got it to work.

gls858