You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Unfortunately in my experience CLEAN doesn't work that well. It can't remove zero width spaces for instance https://en.wikipedia.org/wiki/Zero-width_space (which caused me a great deal of swearing as they also don't show up when you press F2 to edit, due to being zero width).
@ChainBreaker removing zero width spaces is worth trying.
Go to this website https://coolsymbol.com/#non-printing-chars-table
Click to copy Zero-Width Space (ZWSP) Character
In Excel press Ctrl+H to get Find and Replace.
Paste the ZWSP into the Find, leave Replace blank and click Replace All.
If it says it made some replacements that may well be your problem.
aggi
today I learned...
there's a CLEAN function...
removes non printable characters
Try that. =CLEAN(A1)