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: 

	A	B
1	EDIT EXCELLENTABLE	EDIT EXCELLENTABLE