How to search for "@" in text string?

[Robert Brown]

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
*@excel.com.

Thanks

 

[Teethless mama]

A1: holds excel.com

In B1: ="*@"&A1

 

[Dave Peterson]

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

will both return True if A1 contains @.

 

[Robert Brown]

That I could have done if I knew for sure it did not exist. That's the point
of testing the string before appending.

 

[Robert Brown]

isnumber worked, countif didn't

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

 

[Dave Peterson]

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.