Definition/Description of Formula:

Removes leading and trailing spaces in a specified string.



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



  • 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: 



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