I have cell A1 that contains text in this format:

varioustext (varioustext@varies.com)<othertext (otheremail@varies.co.uk)

as you probably guessed it is a list of emails. the emails are the only text that is within brackets, I need to get each email address into a list where:

A1= varioustext@varies.com B1= otheremail@varies.co.uk etc..

Can anybody help me on this?