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 and Quote

You can call us now on 020 3817 6945 or fill out the form below.

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

The contact form requires that you select an email template.

Access Database and Excel Spreadsheet Developers

Call us : 020 3817 6945

Email us : info@xlteq.com

Find us : Unit 1, Wood Green Farm Buildings, Upper Basildon, Berkshire, RG8 8NA

Made with by BarkWeb Platform: Jolojo