Restricting number of characters and special characters in Cell

[dshim86]

I am trying to restrict entry of special characters and limit the amount of alphanumeric values to less than or equal to 18 in a cell, please help!

 

[DRSteele]

Apply a Data Validation rule to the cell. Select 'Text Length' under Allow, select 'Less than or equal to' under Data and put 18 in 'maximum'. Select the 'Ignore Blanks' checkmark depending upon whether you want a blank to count as one of the 18 characters. Set the other controls regarding messages etc. This will take care of the 18 criteria.

To restrict entry to specific characters only, I suspect you will need a VBA solution, something not in my bailiwick.

 

[dshim86]

thank you but I need both limits set. Was wondering if there was an IF statement formula?