Introduction

```html

Remove Leading, Trailing, and Extra Spaces in Excel

Introduction

Excessive spaces between words in Excel cells can hinder data analysis and readability. Fortunately, Excel provides several methods to remove these unwanted spaces.

Method 1: TRIM Function

Syntax

TRIM(text)

Usage

The TRIM function removes all leading and trailing spaces, as well as consecutive spaces within the text string. It leaves only single spaces between words.

For example, to remove spaces from the string " Example String ", use the following formula:

=TRIM(" Example String ")

Result

"Example String"

Method 2: SUBSTITUTE Function

Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])

Usage

The SUBSTITUTE function allows you to replace all or a specific number of occurrences of a character or string with another character or string.

To remove all spaces from a string, use the following formula:

=SUBSTITUTE(text, " ", "")

Result

"ExampleString"

Method 3: Excel Add-in

There are several Excel add-ins available that can efficiently remove extra spaces between words.

You can find and install these add-ins from the Microsoft Office Store.