Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*") cynichromantique Excel Worksheet Functions 9 September 25th 08 09:49 PM
Converting "uppercase" string data to "lower case" in CSV file [email protected] Excel Discussion (Misc queries) 2 August 12th 08 08:36 PM
text string: "91E10" in csv file auto converts to: "9.10E+11" [email protected] Excel Discussion (Misc queries) 2 August 12th 08 03:13 PM
Text stored in a cell is displayed as a string of "#####..." David Walter Excel Discussion (Misc queries) 5 November 12th 07 08:53 PM
Counting cells that "contain" a text string Dave Excel Discussion (Misc queries) 2 September 5th 07 05:16 PM


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"