getting the text between <>

[mac10001]

Hi All,

I've been given a messy excel sheet with email addresses. With messy I mean some rows have an "email address", others have "first name last name <email address>", others have well I will probably ask about those later, in the mean time. I want to get all the email addresses only from the "first name last name <email address>", in other words, I want to pick out anything between the < >, I am hoping there's a way to do this other than manually. Does anyone have any suggestions?

Your help is appreciated!

Mac

 

[Michael M]

Hi and Welcome to the Board
Can you post a couple of samples of what you have , and the desired result.
It's way easier than trying to explain it.

 

[mac10001]

Thanks for the reply Michael,

Here's what the cells look like: john doe <john.doe@gmail.com>
Here's what I want the cells to look like: john.doe@gmail.com

Thanks again.

Mac

 

[mac10001]

This did not come our right for some reason

The way the cells look is : john doe <john.doe@gmail.com>
The way I would like for them to look is : john.doe@gmail.com

 

[mac10001]

Lets try this again, the system is screwing it up.

The way the cells look is : john doe <email address>
The way I would like for them to look is : email address

 

[narendra]

Let us assume the name and email address is in cell "A1" and it looks something like this: "Adam Smith <adamsmith@aol.com>" and then the email address in between </adamsmith@aol.com>"<" and ">" sign.

<adamsmith@aol.com>Use the below formula into an adjecent cell to get the email address. In this case it will extract the text value "adamsmith@aol.com" without the quotes.

=MID(A1,FIND("<",A1)+1,FIND(">",A1)-FIND("<",A1)-1)

As long as you have an email address between "<" and ">" sign, the above formula should work fine.
Hope this helps.</adamsmith@aol.com>

 

[mac10001]

Thank you very much Narendra!!!!!!! That works.

I apologize for my 3 messed up relies, for some reason the forum is not showing anything I put between "<" and ">", I put in 3 different ways and it magically disappeared every time!

Again, thank you very much Narendra and Michael for helping out!

 

[narendra]

U r welcome.

I am glad that i could be of some help.

This thread resolved.

 

[Michael M]

The reason the text is not working is because you need to put a space before / after the <> signs otherwise the system thinks it's a HTML Tag.