Expert Excel Tips from Xlteq - Trim
Have you ever tried to lookup an item in a list and found that Excel says there is no match when you can see it right in front of you?
This is often due to leading and/or trailing spaces in the text.
To remove these spaces, use =TRIM(text).
All you need to do is refer to the cell from where you want to remove leading and trailing spaces and it will return the text without those extra spaces.