TRIM function is used to remove more then one space between the 2 words , sentence , In simple language its used to remove unnecessary space. And its very useful when you use to match the two data in different cell. .
Example Shown in below image.
FORMULA =TRIM(A2)
I have been looking for a solution in this regard for the last two days. Finale I got the solution. Thank you
Nice helpful