Hello, I have data from uncontrolled sources which contains non printing characters. I can't use the clean option because the data is too inconsistent. It seems the most common problem is the user hitting alt+enter rather than using word wrap to stack lines in a cell.
The best case scenario is to have the characters highlighted so I can see them and edit as needed. I'm not sure which method is best to accomplish this so I posted it in the general area.
Thanks for any help!
Bookmarks