The following lines with graphics characters are Email Subject lines I obtained from Outlook using VBA.
✅ Your Holiday To-Do List! Plus, Get...
FLASH ENDS SOON! Huge Garmin GPS...
How do I get rid of the graphics characters using Excel VBA to end up with plain ASCII Text?
Sample file attached.
I suppose, you could use formula
Formula:
Please Login or Register to view this content.
graphics characters.JPG
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you AlKey. I was hoping for a general solution, since the two items I posted are just a small sample of the graphics characters I get.
You can tweak this regular expression
Please Login or Register to view this content.
Perhaps a function like this
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
@AB33: Thank you. Special characters are removed, but it also removes ASCII spaces.
@xlinitwit: Perfect. Thank you.
You're welcome- thanks for the rep.
Try this pattern, just replace the pattern line in to
Please Login or Register to view this content.
Last edited by AB33; 12-06-2017 at 02:02 PM.
Thank you AB33. Now it works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks