Text Cleaner

Text Cleaner

Paste a value, or a whole column of them (one per line). This strips the invisible and stray characters that stop text from matching between spreadsheets, forms, and configuration fields, non-breaking spaces, zero-width characters, tabs, line breaks, and Excel _x000D_ escapes. Everything runs in your browser; nothing is uploaded or stored.

Ready

Type or paste above to check for hidden characters.
Normal spacing
keeps single spaces between words

    
No spaces
removes all spaces (compact form)

    

How to use

  1. Copy the value you are having trouble with, and paste it above.
  2. If anything is flagged, copy the cleaned version you need, Normal spacing to keep spaces, or No spaces for a compact value.
  3. Paste the cleaned value back where you need it. A clean value matches; a hidden character does not.