How to search for "@" in text string?
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
|