TRIM Function

The TRIM function removes all the extra spaces (except the single space between words) from the given text.
Note: This function can be used on text that we receive from another application as it may have irregular spacing.

Formula:


=TRIM(Text)
Whereas "Text" is the set of characters to be trimmed

Video Tutorial:


Let us remove the extra spaces from the given text, using the TRIM function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question