ops ... set_c as definited name: ="ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_"
the array romula not with name is:
=IF(ISERROR(SEARCH("@",A2)),"",MID("
"&LEFT(A2,SEARCH("@",A2)),MAX(IF(ISERROR(SEARCH(MID("
"&A2,ROW(OFFSET($A$1,,,SEARCH("@",A2))),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_")),ROW(OFFSET($A$1,,,SEARCH("@",A2&"
")))))+1,1000)&MID(A2,SEARCH("@",A2)+1,MIN(IF(ISERROR(SEARCH(MID(A2&"
",ROW(OFFSET($A$1,SEARCH("@",A2),,1000)),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_")),ROW(OFFSET($A$1,SEARCH("@",A2),,1000))))-SEARCH("@",A2)-(MID(A2,MIN(IF(ISERROR(SEARCH(MID(A2&"
",ROW(OFFSET($A$1,SEARCH("@",A2),,1000)),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_")),ROW(OFFSET($A$1,SEARCH("@",A2),,1000))-1)),1)=".")-1))
regards
r
https://sites.google.com/site/e90e50fx/home/estrarre-indirizzo-mail-da-testo
2011/3/27 siti Vi <villager.g...@gmail.com>
> Dear Mr. Ayush
>
> Please try
>
> =TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))-1)," ",REPT("
> ",99)),99))
>
> or (Array Formula:)
> =MID(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))),COUNT(SEARCH("
> *@",A2,ROW($1:$103)))+1,99)
>
> thank you and best regards
> siti Vi
>
>
>
> On Sat, Mar 26, 2011 at 9:52 PM, Ayush <jainayus...@gmail.com> wrote:
>
>> Hello Group,
>>
>> Learn to extract email address from the string in the cell. Visit :
>> http://www.discussexcel.com/functions
>>
>> Feel free to share ideas you might have for the same task. I will
>> appreciate it.
>>
>> Thanks and best regards
>> Ayush Jain
>>
>>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
estrai indirizzo mail-1.xls
Description: MS-Excel spreadsheet
