Definition/Description of Formula:

Removes leading and trailing spaces in a specified string.


Syntax:

TRIM(text)

  • text - The string or reference to a cell containing a string to be trimmed.

 

Notes

  • It is important to use TRIM when text is used in formulas or data validation because spaces in front of or after the text are significant.
  • TRIM removes all spaces in a text string, leaving just a single space between words.

 

See Also: 

REPLACE: Replaces part of a text string with a different text string.

 


To use the TRIM Formula, simply begin with your edited Excellentable:  

Then begin typing the TRIM formula in the area you would like to display the outcome: 

 

Error.

User does not have sufficient privileges to access this Content
Learn More