Clean up text
Remove strange hidden characters
=TRIM(CLEAN(A2))How it works in Excel
- CLEAN removes characters that do not print.
- TRIM then tidies the spaces.
- This suits text copied from websites or other systems.
- A web space (CHAR(160)) needs SUBSTITUTE instead.
The idea in general
Pasted text can carry invisible junk, and this strips it out.
What I assumed
- The messy text is in A2.
Check the result on your own data before relying on it.