deleting part of a cell

[tolly]

Hello

I have a huge Excel database of 10000 email addresses, and in order to import them in to my email accounts address book, I need to remove the the persons name so I am just left with the email address.

ie;

(All in one cell)
John Smith <johnsmith@help.co.uk>

needs to become

<johnsmith@help.co.uk>

I am wondering if there is an action or something that I can run so I don't have to delete each name by hand more than 1000 times?

Hope someone can help.

Kind Regards

[Richard Buttrey]

Hi,

Use a helper column and use

Please Login or Register  to view this content.

Copy this down your 1000+ rows then if necessary copy and paste special on top of the original data.

HTH

[royUK]

Here's a User Defined Function

Please Login or Register  to view this content.

Use as an ordinary function

=getmailadd(A1)