How to remove invalid characters with a macro in Excel
How to discard invalid characters and leave remaining characters.Determine which characters are invalid.
For more help visit my website or email me at easyexcelanswers@gmail.com.
I can customize this Excel application for your exact needs for a fixed price of $50. The work is normally returned within 24hrs.
I am able to provide online help on your computer at a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
Sub Invalid()
Dim e
For Each e In Array(“~”, “`”, “!”, “#”, “$”, “%”, “^”, “*”)
If e Like “[*?~]” Then
Columns(“a”).Replace “~” & e, “”
Else
Columns(“a”).Replace e, “”
End If
Next
End Sub
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Nice video, but I was wondering about this: how can Unicode Block characters (i.e., replacement characters, such as "diamond with question mark" or �) be referenced in the visual basic editor, and not just commonplace symbols? Thank you!
Hello ,I tried using your code mentioned above. But it is limited to only one column at a time. Can you help me in making a code for removing Invalid characters for the selected rows and columns in excel. If so ,that would be really helpful. Thank You.
Handy Macroo
Thanks a lot of you mam