Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to remove multiple @ signs from email?
i am new user. Currently there is email addresses in col. a, but sometimes
it does not contain valid email id's, how can i remove those invalid email ids (containing no @ sign, or containing @ sign twice, contains a : or / ) how do i check to see whether they are correct? Your guidance will be helpful to me. TIA Mahesh India |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to remove multiple @ signs from email?
=IF(OR(ISERR(SEARCH("@",A1)),COUNTIF(A1,{"*@@*","*/*","*:*"})0),"",A1)
"mahesh @gmail.com" wrote: i am new user. Currently there is email addresses in col. a, but sometimes it does not contain valid email id's, how can i remove those invalid email ids (containing no @ sign, or containing @ sign twice, contains a : or / ) how do i check to see whether they are correct? Your guidance will be helpful to me. TIA Mahesh India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email Macro with Outlook Express | Excel Discussion (Misc queries) | |||
Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
How may I remove Office 2003 DRM protection from DOC & XLS files? | Excel Discussion (Misc queries) | |||
Remove Email address header | Excel Discussion (Misc queries) |