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: