TRIM Formula

TRIM formula returns a text value with the leading and trailing spaces removed.

Syntax of TRIM Formula:

TRIM( text )

Parameters Details:

text : The text value to remove the leading and trailing spaces from.

Returns

The TRIM function returns a string/text value.