For ? and / you can use

=ISNUMBER(FIND("/",A2)) etc..

For *, best to use

=ISNUMBER(FIND(CHAR(42),A2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"linglc" wrote in message
...
How do I test if a cell has any of the special characters e.g. *,?,/
Thanks for any help.