JUSTOUTOFMYREACH
New Member
- Joined
- Dec 11, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Nevada.
Utah.
Texas
Washington
Change to:
NV
UT
TX
WA
Utah.
Texas
Washington
Change to:
NV
UT
TX
WA
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Abbreviating States 100+ rows 1 column.
- Thread starter JUSTOUTOFMYREACH
- Start date
-
- Tags
- abbreviate copy
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,561
- Office Version
- 365
- Platform
- Windows
Are the state names the only thing in the cell?
If so you can create a LOOKUP table with two columns, one for state name and the other for state abbreviation.
Then use a XLOOKUP formula to look up the abbreviation for each one.
See: XLOOKUP function - Microsoft Support
If so you can create a LOOKUP table with two columns, one for state name and the other for state abbreviation.
Then use a XLOOKUP formula to look up the abbreviation for each one.
See: XLOOKUP function - Microsoft Support
Upvote
0
