TRIM function in Excel is used to remove the extra spaces from text. After applying TRIM function, multiple spaces in between text strings will be trimmed to a single space and there won’t be any space character at the start and end of the data.
Remove extra spaces.
Text without unnecessary spaces
text – text data from which extra spaces are to be removed.
TRIM removes only the ASCII space character (32) from text data. To remove the first 32 non-printing characters (ASCII values from 0 to 31), use CLEAN function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)
New Dynamic Array Functions in Excel