How to search for "@" in text string?
 

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

How to search for "@" in text string?
 

A1: holds excel.com

In B1: ="*@"&A1



"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

How to search for "@" in text string?
 

=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

How to search for "@" in text string?
 

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

"Teethless mama" wrote:

A1: holds excel.com

In B1: ="*@"&A1



"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

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

How to search for "@" in text string?
 

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