Thread: Remove part of text in each cell, long list, help please!

Hello EF! I'm new here and even if no one can help, this is a great resource. So thanks already!

Anyway, here's my situation...

I'm using Excel Mac 2011 and have a long list of e-mail addresses (2000+).

I need to import these to my e-mail broadcasting service, however, only some can be read because the addresses look like this:

"email@domain.com <email@domain.com>"

This text is in single cells.

I'm looking for a way (rather than manually) to remove the "<email@domain.com>" part of the text in each cell, automatically.

It's quite a long list, so this would really help to save time.

I looked at the replace tool and have also wondered if there is a some kind of function I can run to achieve this. I'm just not sure where to start!

Any help, much appreciated.

Cheers,

Matt

Originally Posted by DonkeyOte

Perhaps try Edit -> Replace replacing: <* with nothing.

Worked a treat. You've just saved me a few hours and made me feel pretty good.

Thank you!