M HYPE SPLASH
// general

Excel: Change U.S. State Abbreviation to Full State Name?

By Emma Terry

Is there a MS Excel add-on or something that will Change U.S. State Abbreviation to Full State Name?

Change:

GA to Georgia
CA to California
FL to Florida

This is brutal doing Find and Replace because:

Find: ID
Replace: Idaho 

Which then changes Florida to Floridahoa.

So i'm constantly going back and forth fixing that mess...

Thanks

7 Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy