Restricting typing of special characters

The Sheet does not have a Keypress event so preventing the typing of special characters dynamically will be out of the question.

However there are a couple of strategies you can use to help prevent or strip away offending chars after the fact...

One strategy would be using Data Validation .... http://www.tvmcalcs.com/blog/comment...ta_validation/

Another using Code after the fact say developing a macro to strip all special characters in a column which would be run after entry...

Please Login or Register  to view this content.