software

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: www.excelforum.com/member.php...oamp;userid=33133
View this thread: www.excelforum.com/showthread...hreadid=529435Select that column.
Edit|replace
what: *( (asterisk followed by open parenthesis)
with: (leave blank)
replace all

And do it again
edit|replace
what: )* (close paren followed by an asterisk)
with: (leave blank)
replace all

(you may not need the asterisk in the second edit|replace, but it won't hurt.)

nanox wrote:
gt;
gt; Ok I have a spreadsheet and in one of the columns is formatted for email
gt; addresses and names like:
gt;
gt; Bob Davis )
gt; James smith )
gt;
gt; I want to remove the name and the brackets and just have the email
gt; address in the column like:
gt;
gt; bd2222(at)aol.com [I wrote (at) because the forum formated it
gt; as a hyperlink]
gt; js5stre(at)yahoo.com
gt;
gt; Is there a formula I can run or any tips would be grateful
gt;
gt; Thanks.
gt;
gt; --
gt; nanox
gt; ------------------------------------------------------------------------
gt; nanox's Profile: www.excelforum.com/member.php...oamp;userid=33133
gt; View this thread: www.excelforum.com/showthread...hreadid=529435

--

Dave Peterson


Worked Perfect!

Thank you very much. --
nanox
------------------------------------------------------------------------
nanox's Profile: www.excelforum.com/member.php...oamp;userid=33133
View this thread: www.excelforum.com/showthread...hreadid=529435