Data Entry Validation to prevent special characters

[Exceller12]

I have a workbook that has several text fields that must be entered. However, there are three special characters which should cause an error message to appear which are <>;

I am trying to enter a formula into the Custom Data validation but am having issues with creating one to do what I need it to.

 

[Robert Mika]

try here:
http://www.tvmcalcs.com/blog/comments/disallow_special_characters_using_data_validation/

 

[T. Valko]

I have a workbook that has several text fields that must be entered. However, there are three special characters which should cause an error message to appear which are <>;

I am trying to enter a formula into the Custom Data validation but am having issues with creating one to do what I need it to.

Try this...

Assume the cell in question is A1.

As the validation formula use:

=ISERR(FIND("<",A1))+ISERR(FIND(">",A1))+ISERR(FIND(";",A1))=3

 

[Exceller12]

This worked!

This was very helpful.

Thanks alot

 

[T. Valko]

This worked!

This was very helpful.

Thanks alot

You're welcome. Thanks for the feedback!