remove partial data from cell
 

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

remove partial data from cell
 

Select 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:

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

--

Dave Peterson

remove partial data from cell
 

Worked Perfect!

Thank you very much. :)


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