View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Expand Abbreviations For State Names

Here's a list you can start with:

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

--JP

On Jan 29, 12:02*am, "Fred Smith" wrote:
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