Trim spaces in cells or columns - Excel Tips & Add-ins

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Trim spaces in cells or columns in Excel

The preceding and trailing spaces in cells are often unnoticeable. A cell that look like 'word' can actually be 'word '. This causes problem when you filter, match table, join (merge), or find duplicates. Therefore, it is always safe to do some trimming first, to trim out the preceding and trailing spaces if there is any.

Practice file - trim-demo.xls (16k)

Select a range of cells, invoke 'Selected Area->Trim...', the cells will be trimmed in-place

Cells will be trimmed in-place

Trim spaces in cells or columns

You can also select a single cell in a table's column, invoke 'Column->Trim...', this will trim the entire column, and the trimmed values will be placed in a newly inserted column next to the original column.

Trimmed values are put into a new column

Trim spaces in cells or columns

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.