Skip to main content


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.