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.
Excel Tips Trim
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.
For a free consultation
Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.