We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Wednesday April 29th, 2026

Tip of the Day | Wednesday April 29th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Remove Leading, Trailing, and Extra Spaces Between Words

This tool removes unnecessary spaces from your selected cells by trimming the beginning and end of each value and reducing multiple spaces between words to a single space.
For example:
  • "Lennox Street 141 " becomes "Lennox Street 141"
  • "  John A. Smith " becomes "John A. Smith"
  • " email@example.com " becomes "email@example.com"
  • " Multiple spaces     in    between " becomes "Multiple spaces in between"
    It works like Excel's TRIM() function but with enhancements.
    Unlike TRIM(), this tool also removes leading and trailing nonbreaking spaces (character 160), which sometimes appear in data copied from websites or exported from other systems. These spaces are visually identical to regular spaces but are not removed by Excel's TRIM. In web content, they often show up as the HTML entity.
    As an added bonus, this tool also helps fix cells that contain a zero-length string. Microsoft uses this term for values that look blank but actually contain invisible content, such as a single apostrophe or the result of a formula like "" that was pasted into the cell as a value. After cleanup, Excel will recognize these cells as truly empty.
    Cells that contain only spaces (including nonbreaking spaces) will be turned into empty cells.
    Cells with formulas are left unchanged.
    This is especially useful when cleaning up imported or pasted data, fixing lookup errors (e.g., VLOOKUP, XLOOKUP), or preparing clean, consistent text for reports, sorting, and filtering.

    Screenshots

    Example screenshot: 1 Before
    1 Before
    Example screenshot: 2 Strip the leading, trailing and duplicated spaces
    2 Strip the leading, trailing and duplicated spaces
    Example screenshot: 3 After
    3 After

    Starting this tool


    Text  ›  Remove Leading, Trailing, and Extra Spaces Between Words

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.