Excel Function : TRIM

Download now!

Excel Function : TRIM

Category

Text

Description

Removes spaces from text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TRIM-function-410388fa-c5df-49c6-b16c-9e5630b479f9

Syntax and Description of the TRIM Excel Function

The syntax for the TRIM function in Microsoft Excel is as follows: =TRIM(text) Where text is the text string that you want to trim.

About TRIM Excel Function

The TRIM function in Excel removes all spaces from a text string except for single spaces between words. For example, the text string " Hello World " would become "Hello World" after using the TRIM function.