Ok I have a spreadsheet and in one of the columns is formatted for email
addresses and names like:

Bob Davis )
James smith )

I want to remove the name and the brackets and just have the email
address in the column like:

bd2222(at)aol.com [I wrote (at) because the forum formated it
as a hyperlink]
js5stre(at)yahoo.com

Is there a formula I can run or any tips would be grateful

Thanks.


--
nanox
------------------------------------------------------------------------
nanox's Profile: http://www.excelforum.com/member.php...o&userid=33133
View this thread: http://www.excelforum.com/showthread...hreadid=529435