Trim Spaces

Remove extra leading, trailing, and inner whitespace from cells.

About Trim Spaces

Trim Spaces clears leading and trailing whitespace and collapses multiple internal spaces into one — fixing the formatting issues that quietly break lookups and joins.

Frequently asked questions

Yes. All whitespace characters (tabs, line breaks, non-breaking spaces) are normalized.

More data cleaning tools

Browse other categories