isnumber worked, countif didn't

Interesting that the @ symbol can't be searched for using standard string
functions.

"Dave Peterson" wrote:

=isnumber(search("@",a1))
or
=countif(a1,"*@*")0

will both return True if A1 contains @.


Robert Brown wrote:

I haven't found the magic way to search for the @ symbol in a character
string. Is there a special way to key this so FIND will work?

If that's not possible, any suggestions on converting just domain names to
wild carded email address formats? IE: take excel.com and convert to
.

Thanks

--

Dave Peterson