Extract email ids some rows with in brackets and some direct email ids

[miboyfrend]

I have a column of email ids as given below and i want to extract email ids into the next column

abc@abc.com
Mr.Muscle (muscle@gym.com)
xyz@yahoo.co.az
Regular visitor (visitor@gym.com)

 

[FormR]

Welcome to MrExcel!

One option:

Excel Workbook
	A	B
1	abc@abc.com	abc@abc.com
2	Mr.Muscle (muscle@gym.com)	muscle@gym.com
3	xyz@yahoo.co.az	xyz@yahoo.co.az
4	Regular visitor (visitor@gym.com)	visitor@gym.com
Sheet1

 

[FormR]

One more option:

Excel Workbook
	A	B
1	abc@abc.com	abc@abc.com
2	Mr.Muscle (muscle@gym.com)	muscle@gym.com
3	xyz@yahoo.co.az	xyz@yahoo.co.az
4	Regular visitor (visitor@gym.com)	visitor@gym.com
Sheet1