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!
Hi Coleslaw and welcome to the forum
Have you tried to use the substitute() and trim() functions? You may have to do it a few times to get them all, use the char() function for "invisible" characters, find the number by using code()
char(13) = alt enter
char(10) = |
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks