View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Expand Abbreviations For State Names

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"" wrote in message
...
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