Excel Formulas to Normalize the Text ~ A Complete Tutorial!!
Tags: excel
Published: 2021-06-21 02:47:42

---
title: Excel Formulas to Normalize the Text ~ A Complete Tutorial!!
published: true
date: 2021-06-14 04:47:00 UTC
tags: Excel
canonical_url: https://geekexcel.com/excel-formulas-to-normalize-the-text-a-complete-tutorial/
---

Sometimes, while you import some text string from other devices or locations, they may with some punctuations, extra spaces, or upper cases which you want to remove and adjust. Here this tutorial introduces a formula that helps you to **normalize the text in Excel**. Let’s jump into this article!! 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)

[![Normalize the text](https://geekexcel.com/wp-content/uploads/2021/06/Normalize-the-text.png)](https://geekexcel.com/?attachment_id=46381#main)<figcaption id="caption-attachment-46381">Normalize the text</figcaption>

## General Formula:

- If you want to normalize the text in Excel, you can use the below formula.

**=[LOWER](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/)([TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)([SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,”(“,” “),”)”,” “),”-“,” “),”:”,” “),”;”,” “),”!”,” “),”,”,” “),”.”,” “)))**

## Syntax Explanations:

- **LOWER** – The [**LOWER function**](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/) returns a lower-case version of a given text string.
- **TRIM** – This function removes the extra spaces from the text and there is no space at the start or end of the text string. Read more on the [**TRIM function**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **SUBSTITUTE ** – In Excel, the [**SUBSTITUTE function**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/) replaces existing text with new text in a text string when you want to replace text based on its content, not position.
- **A1** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input values in **Column B**.
- Here we need to normalize the text.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-28.png)<figcaption id="caption-attachment-46380">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-38.png)<figcaption id="caption-attachment-46379">Enter the formula</figcaption>

- Finally, press the ** ENTER** key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-31.png)<figcaption id="caption-attachment-46378">Result</figcaption>

## Verdict:

In this chapter, we have described the formulas to **normalize the text in Excel**. Hope you like it. Mention your **queries** in the **comment** box below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Extract the Substring ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-extract-the-substring/)**
- **[Excel Formulas to Get the Last Word of a Text String ~ Quick Method!!](https://geekexcel.com/excel-formulas-to-get-the-last-word-of-the-text-string/)**
- **[Formulas for Extracting Substring Between Two Texts in Excel 365!!](https://geekexcel.com/formulas-for-extracting-substring-between-two-texts-in-excel-365/)**
- **[Excel Formulas to Count Total Words in a Range ~ Useful Tips!!](https://geekexcel.com/excel-formulas-to-count-total-words-in-a-range/)**