Skip to Content

TRIM

Removes spaces from text, leaving only single spaces between words

Syntax

TRIM(text)

Parameters

  • text: Required. The text from which you want spaces removed

Example

=TRIM("  First   Quarter  ")
Returns: StringSince: Excel 2003