Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
Text stored in a cell is displayed as a string of "#####..." | Excel Discussion (Misc queries) | |||
Counting cells that "contain" a text string | Excel Discussion (Misc queries) |