Whitespace Remover
Strip extra spaces and blank lines from text in one click.
About this calculator
Strip unwanted whitespace from text: leading and trailing spaces, double spaces, tabs, blank lines and line breaks. Each option can be switched on or off.
Cleaning whitespace helps when data copied from a PDF or spreadsheet misbehaves in a form, formula or database.
How to use it
- Paste your text.
- Choose the options.
- Press Clean Whitespace and copy the result.
What is removed
Leading and trailing spaces are removed from each line. Runs of spaces collapse to one. Tabs become spaces. Blank lines are deleted. Line breaks can be converted to spaces to produce one line.
Worked example
' hello world '
| After | hello world |
Tips and common mistakes
- Trim data before using VLOOKUP or MATCH, since trailing spaces break matches.
- Non-breaking spaces from web pages may need the Text Cleaner.
- Keep line breaks for addresses; remove them for single-line fields.
- Check the result before replacing the original.
- Use it on CSV fields to avoid hidden spaces.
Frequently asked questions
How do I remove extra spaces from text?
Paste it and press Clean Whitespace.
Does it remove double spaces?
Yes, if the collapse option is ticked.
Can it delete blank lines?
Yes.
Why do trailing spaces matter?
They cause look-ups and comparisons to fail.
Will it remove tabs?
It converts them to spaces.
Does it change letters?
No.