In this tutorial, we will guide you to know the simple formulas to abbreviate state names in Excel 365 with basic examples and syntax. Let’s step into this article and learn the formulas!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- Use the below-mentioned formula to abbreviate state names in Excel.
=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(name,states,2,0)
Syntax Explanation
- VLOOKUP – The VLOOKUPfunction is used to lookup data in a range or table by row.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example
Let’s consider the below example. Here we are going to abbreviate state names in Excel.
- For instance, you need to create a sample data in the Excel.
- Then, to convert full state names to their two letter abbreviation, you have to use the below given formula in the formula bar.
=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(C5,states,2,0)
- Now, you will get the *result * as shown below in the Excel.
- Finally, copy down the formula to get the result as a letter abbreviation for all cells.
Verdict
From this bride tutorial, we have learned the formula to abbreviate state names in Excel 365 with practical examples. Go for it. If you have any doubts, feel free to share them with us. Thank you!! To learn more about Excel, just click here: **Geek Excel!! **Keep Learning with us!!
Continue Reading:
- How To Change the state of a custom CommandBar button using VBA in Excel?
- Get Sheet Names in Excel Office 365 ~ Quick Steps!!
- List All Worksheet Names with Hyperlinks as Table of Contents in Excel!!
- Excel Formulas to Get the Name of Nth Largest Value!!
- Excel Formulas to find Average last N values in a table in Excel!!
Top comments (0)