Excel Formulas to Abbreviate state names in Excel 365!!
Tags: excelformula, excelformulas
Published: 2021-10-30 11:06:28

---
title: Excel Formulas to Abbreviate state names in Excel 365!!
published: true
date: 2021-10-29 11:48:38 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-abbreviate-state-names-in-excel-365/
---

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](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 **[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**function 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.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-70-1024x510.png)<figcaption>Sample data</figcaption>

- Then, to convert full state names to their two letter abbreviation, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(C5,states,2,0)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-21-1024x576.png)<figcaption>Use the Formula</figcaption>

- Now, you will get the  **result ** as shown below in the Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-1-2-1024x519.png)<figcaption>Output</figcaption>

- Finally, copy down the **formula** to get the result as a letter abbreviation for all cells.

![](https://geekexcel.com/wp-content/uploads/2021/10/Final-Output-4-1024x516.png)<figcaption>Final Output</figcaption>

## 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](https://geekexcel.com/)!! **Keep Learning with us!!

**Continue Reading:**

- **[How To Change the state of a custom CommandBar button using VBA in Excel?](https://geekexcel.com/how-to-change-the-state-of-a-custom-commandbar-button-using-vba-in-excel/)**
- **[Get Sheet Names in Excel Office 365 ~ Quick Steps!!](https://geekexcel.com/how-to-get-sheet-names-in-excel-office-365-quick-steps/)**
- **[List All Worksheet Names with Hyperlinks as Table of Contents in Excel!!](https://geekexcel.com/list-all-worksheet-names-with-hyperlinks-as-table-of-contents-in-excel/)**
- **[Excel Formulas to Get the Name of Nth Largest Value!!](https://geekexcel.com/excel-formulas-get-name-nth-largest-value/)**
- **[Excel Formulas to find Average last N values in a table in Excel!!](https://geekexcel.com/excel-formulas-to-find-average-last-n-values-in-a-table-in-excel/)**