Validation on insert of special symbols

Hi all,

I want to do a validation so that users cannot insert special symbols like (*,&, ' , " etc ) in the cell .

How can i do this?
Please help me with this.

Thank you,
Glen

Please Login or Register  to view this content.

Thanks Kaak,

But it does not work if i enter enter value as test* _name

I must give an error in msgbox when ever a user enters a name in Column C
which has a special character.