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.


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