TRIM Function Explained
The TRIM function in Microsoft Excel removes all extra spaces from a text string, including leading, trailing, and double spaces between words. It takes a single argument, which is the text string to be trimmed. The function returns the trimmed text string.
TRIM Function Syntax
TRIM(text)
- text: The text or reference to a cell containing text for which you want to remove all extra spaces.