If you want the test all in one, try

=SUMPRODUCT(--(ISNUMBER(FIND({"*","/","?"},A1))))0

--
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.