Highlight special (dis-allowed) characters in a worksheet
Looking for a way to clean up data in an Excel worksheet that is to be
imported to a database. Much of the data is text. Only certain characters
can be allowed (essentially those found on the keyboard). Would prefer to
have the dis-allowed characters highlighted in some way (color change, bold,
etc.). I can identify allowable characters by ASCII code. Has anyone seen
or willing to provide an add-in or macro that would suit my needs?
Thanks very much!
Jack
|