Excel TRIM function

The TRIM function removes excess spacing from text strings, leaving just a singular space in between words and no spaces at the start/end of the text string. It can be particularly useful when looking to clean up messy data.

Syntax

=TRIM(text)

Arguments

text – the input text (usually via a cell reference) from which you wish to remove excess space.

Function category

Text

Returns

The TRIM function returns the contents of the input cell, stripped of excess spaces.

Download Excel File

 Example of TRIM Formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.