TRIM Function
Purpose
Strips all leading, trailing, and repeated internal spaces from a text string, leaving only single spaces between words.
Syntax
EXCEL
=TRIM(text)
Strips all leading, trailing, and repeated internal spaces from a text string, leaving only single spaces between words.
=TRIM(text)