What the Invisible Spaces Are
Key points
- Paste the text
- Choose the item
- Check the counts
Excel Text Cleaner removes no-break spaces, zero-width spaces and the like.
Steps
- Paste the text
- Choose the item
- Check the counts
The difference in counts before and after shows how many were removed.
Use "Remove Extra Spaces and Invisible Characters from Excel Text" (free)
Tools that go well with this
- Convert Full-Width, Half-Width, Hiragana and Katakana: Convert full-width/half-width and hiragana/katakana.
- Remove and Tidy Line Breaks in Text: Tidy line breaks in text copied from PDFs and elsewhere.
- Remove Duplicate Lines and Sort a List: Remove duplicate lines and sort them.