• Excel Tips Trim

  • Excel 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.

     

    Excel Tips Trim Image