Hi,
https://drive.google.com/file/d/0Bzv...it?usp=sharing
You can download the excel from the above link.
This excel includes some text data, in each cell there is an email address along with additional text. I only want to get the email addresses from the entire data.
Hope there is some way of doing this in excel.
Looking forward for your answers!
Will this be helpful?
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
yes... it is really helpful...
I have managed to remove the text after Gmail.com, now all the cell ends with an email address. Can you give me the formula to extract the emails from each cell from the right.
I have uploaded the new file here: https://drive.google.com/file/d/0Bzv...it?usp=sharing
I didn't download your file.
Try this...
Text strings starting in A2.
This formula entered in B2 and copied down:
=TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))-1),
" ",REPT(" ",LEN(A2))),LEN(A2)))
Last edited by Tony Valko; 05-05-2014 at 08:22 AM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks a lot, but it is also getting some extra characters with the email. Not working
you have far to many things leading or following the mail addresses
this should get most of them
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(" "&A2,CHAR(160)," "),"("," "),")"," "),".."," ")," ",REPT(" ",50)),FIND("@",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(" "&A2,CHAR(160)," "),"("," "),")"," "),".."," ")," ",REPT(" ",50)))-25,50))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks