TRIM

Removes all leading and trailing whitespaces from the specified text.

Syntax

TRIM( Text text ) → Text

Parameters

text

Required. The text to trim.

Remarks

The following characters are considered whitespaces by this function: HORIZONTAL TABULATION (U+0009), LINE FEED (U+000A), CARRIAGE RETURN (U+000D) or SPACE (U+0020).

Example

Formula

=TRIM("  Total income: ")

See Also

Function Reference
LEFT Function
RIGHT Function
MID Function
REPLACE Function
SUBSTITUTE Function