Description:
The TRIM function uses to remove the unwanted space between the words. It will keep one space in between each word and removed unnecessary spaces.
Formula Syntax:
Example:
Important points:
You have to remove unwanted texts from respective cells, otherwise Other formula's like VLOOKUP will not give correct results.
Working file
Comments