How To Use TRIM Function | Microsoft Excel

TRIM function will remove the additional spaces in the cell and leave the content with one space between the words. TRIM function converts text from irregular spaces to regular spaces between the words

Syntax of TRIM Function

=TRIM(text)

Arguments of TRIM Function

text: text which you want to remove additional spaces

Behavior of TRIM Function

Here you can see the spaces between the words and line break, which is removed by TRIM function

Usage of TRIM Function

To remove additional spaces from the text.

Return of TRIM Function

Regularly spaced text