Pinterest Pixel

Cleaning Data with Excel’s TRIM Formula

What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Cleaning Data with Excel's TRIM Formula | MyExcelOnline

What does it do?

Removes unneeded spaces in your text, except single spaces in between words

Formula breakdown:

=TRIM(text)

What it means:

=TRIM(text that you want extra spaces to be removed)


In the quest for cleaner data, one of the common scenarios is removing extra spaces in our text.

Extra spaces are very difficult to spot, especially those at the end. The TRIM formula in Excel is one of the Data Cleansing functions and is great if you want to remove extra spaces from text whether it be from the start, middle or at the end of the text.

In a nutshell, the TRIM function in Excel removes unneeded spaces in your text, except single spaces between words.

This is how it is done below (go to the bottom of the page if you want to see the animated gif tutorial):

Cleaning Data with Excel's TRIM Formula | MyExcelOnline
Download excel workbookTrim.xlsx

 

STEP 1: We need to enter the Trim function

Table of Contents

=TRIM

STEP 2: The Trim argument – Which text do we want to remove the extra spaces?

See also  Create a Dynamic Data Range with the OFFSET function

This is our data source:

Cleaning Data with Excel's TRIM Formula

Now place in the first cell as the argument for our Trim Formula.

=TRIM(C9)

 

Cleaning Data with Excel's TRIM Formula

STEP 3: Do the same for the rest of the cells by using the TRIM formula, notice all of the extra spaces have been removed:

Cleaning Data with Excel's TRIM Formula

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Cleaning Data with Excel's TRIM Formula | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!