TRIM

Remove extra spaces from text

Sponsored Link

TRIM
Purpose 
Remove extra spaces from text
Return value 
Text with extra spaces removed.
Syntax 
=TRIM (text)
Arguments 
  • text - The text from which to remove extra space.
Usage notes 

TRIM strips extra spaces from text, leaving only single spaces between words and no space characters at the start or end of the text.

TRIM is useful when cleaning up text that has come from other applications or environments.

Notes:

  1. TRIM only removes the ASCII space character (32) from text.
  2. Unicode text often contains a non-breaking space character (160) that appears in web pages as the HTML entity,  . This will not be removed with TRIM. See the Microsoft article  for more information.

Sponsored Link

0 votes. 0 / 5