TRIM

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: