Excel Tips Trim

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.

Contact us 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.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.