I think you should try the =countif() once again.

If it doesn't work the second time, post your formula and what's in the cell.

What standard string functions were you trying to use to find that string. Both
=find() and =search() (which seem pretty standard for searching for a string)
work ok.



Robert Brown wrote:

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


--

Dave Peterson