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.