Tip of the Day | Thursday March 19th, 2026
Discover new tools to get things done.
Remove Leading and Trailing Spaces
This tool removes all spaces from the beginning and end of the values in your selected cells, while spaces between words or characters are left unchanged. For example, a cell containing "Excel" will be changed to "Excel".Or "1000 AP Amsterdam" stays "1000 AP Amsterdam", keeping the two spaces between the ZIP code and city name. Compared to Excel's TRIM() function, this tool preserves double or multiple spaces between words or characters, which is helpful when spacing has meaning, such as in addresses, codes, or formatted text. It also removes leading and trailing nonbreaking spaces (character 160, ), which sometimes appear in data copied from websites or exported from other systems and are not removed by TRIM(). 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 data, fixing lookup mismatches (VLOOKUP, XLOOKUP), or preparing consistent text values for sorting and filtering. By default, you can launch this tool using the Control+Alt+Shift+T shortcut.
Screenshots
Starting this tool
- Click ASAP Utilities › Text › 10. Remove Leading and Trailing Spaces
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 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.
🏆 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.