How to Remove Extra Spaces, Tabs, and Empty Lines

Extra spaces and tabs can make text look unprofessional and can break matching in spreadsheets, databases, and content tools. Cleanup is especially useful when text is copied from PDFs, emails, web pages, or old documents.

Example input

  First item

Second     item
Third	item
  Fourth item  

Cleanup steps

1. Click Trim Whitespace to remove leading and trailing spaces on each line.
2. Click Use, then click Remove Tabs.
3. Click Use, then click Remove Double Spaces.
4. Click Use, then click Remove Empty Lines.

Output

First item
Second item
Thirditem
Fourth item

Note about tabs

The Remove Tabs action deletes tab characters. If your tabs separate columns, replace them with commas or line breaks before removing them. Otherwise, values from neighboring columns may join together.