Expand Abbreviations For State Names

[Questor]

I am looking for a macro that converts US Post Office abreviations for State
Names into plain English. If one is available please advise.
Thank you,
Questor

 

[Fred Smith]

Most people would use Vlookup for this. Create a table of the 50 states and
their "English" names. Then use a formula like:
=vlookup(a1,States!A:B,2,false)

Regards,
Fred

 

[Questor]

Works a treat. Thanks very much.

 

[JP]

Here's a list you can start with:

http://www.whypad.com/posts/excel-spreadsheet-of-us-states/583/

--JP

 

[JLatham]

Fred, just to clarify why I provided what I did: he specifically asked for a
macro. Additionally, I wasn't sure just exactly HOW he wants to use it, and
that's the reason I came back with the Sub, which could be adapted to use
with a worksheet also.

I agree with you that a VLOOKUP() with a table is much simpler (and in this
case would be much faster).

Sometimes we just don't get quite enough info to give a "spot on" answer, do
we? At least with your input, and JPs, hopefuly Questor now has an option
available that will work for him/her.

 

[Fred Smith]

No worries. From his response, sounds like he's happy (as well as cryptic).

Fred