View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Brown Robert Brown is offline
external usenet poster
 
Posts: 18
Default 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