Extracting email address from text string
Hello, I used this forum for the first time yesterday and the help was fantastic.
How do I extract an email address from within a string of text where the email address can be identified by < at the beginning and > at the end?
eg in cell A1 I have 'dkjfhjdhskjf <[email protected]> skdfhsjhd' and in b1 I want just [email protected]
Thank you
Try this formula
=SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(" ",A1&" ",FIND("@",A1))-1)," ",REPT(" ",255)),255)),"<",""),">","")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you so much - you guys out there are awe inspiring!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks