The TRIM function removes excess spacing from text strings, leaving just a singular space in between words and no spaces at the start/end of the text string. It can be particularly useful when looking to clean up messy data.
Syntax
=TRIM(text)
Arguments
text – the input text (usually via a cell reference) from which you wish to remove excess space.
Function category
Returns
The TRIM function returns the contents of the input cell, stripped of excess spaces.
Comments (No)