Extract email from a distribution list

[Fran10]

How do I extract muiltiple email address from a distribution list?
The entire list is posted in a single row.
I thought about to text to columns first, delimited with ; and paste Transpose, to be in column
After the list is in column i use the formula =MID(A6,FIND("<",A6)+1,FIND(">",A6)-FIND("<",A6)-1) to extract the emails

There is another way to extract all the email with just 1 formula, instead use all these steps?

Thank you

 

[Fluff]

Hi & welcome to MrExcel.

Can you post the actual data, rather than an image.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fran10]

Hi. unfortunately, I have a work computer, and I dont have previlegies to install anything.

 

[Fluff]

In that case can you simply copy paste the data?

 

[JEC]

For example:

=SUBSTITUTE(FILTERXML("<x><y>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"<","#"),">","#")," ",";"),";","</y><y>")&"</y></x>","//y[contains(.,'#')]"),"#","")

 

[Fran10]

This is the data:
Bojaiah, Uday <Uday.Bojaiah@xxxx.com>; Daniels, Barbara <Barbara.Daniels@xxxx.com>; Feher, Scott <Scott.Feher@xxxx.com>; Garner, Lacey <Lacey.Garner@xxxx.com>; Greves, Pamela <Pamela.Greves@xxxx.com>; Hussain, Mohammad H <mohammad.hussain@xxxx.com>; Kim, Sarah <Sarah.Kim@xxxx.com>; Pasha M A, Rizwan <Rizwan.MA@xxxx.com>; Prasad, Durgaram <durgaram.prasad@xxxx.com>; Reitz, Carolyn <Carolyn.Reitz@xxxx.com>; Srinivasa Santosh Kumar, Nanduri <nanduri.srinivasasantoshkumar@xxxx.com>

And this is the formula: =MID(A9,FIND("<",A9)+1,FIND(">",A9)-FIND("<",A9)-1)

 

[Fran10]

For example:

=SUBSTITUTE(FILTERXML("<x><y>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"<","#"),">","#")," ",";"),";","</y><y>")&"</y></x>","//y[contains(.,'#')]"),"#","")

OMG!!!... thank you so much! It works!!! I TRULY REALLY APPRECIATE IT!

 

[JEC]

You’re welcome!