Excel Function : TRIM

Download now!

Excel Function : TRIM




Removes spaces from text

Microsoft Excel Reference Page


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.