Trim Spaces in Excel Online
Remove leading and trailing spaces from Excel cells, fix non-breaking spaces, and clean hidden characters before import.
Why trim spaces matter
Extra spaces break VLOOKUP, duplicate detection, and database imports.
Hidden character cleanup
Enable fix hidden characters to normalize NBSP, zero-width spaces, and tabs.
Combine with dedup
Trim first, then remove duplicate rows for cleaner master data.
FAQ
Does trim affect numbers?
Formatted numbers are cleaned as text values shown in cells.
Can I trim without removing blank rows?
Yes. Disable remove blank rows on the data cleaner tool.
Will middle spaces be removed?
Only leading and trailing spaces are trimmed, not spaces between words.