TRIM

---

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.

Click for More

Working file

Workings.xlsx

Download XLSX • 13KB