remove partial data from cell

N

nanox

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

Bob Davis ([email protected])
James smith ([email protected])

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.
 
D

Dave Peterson

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.)
Ok I have a spreadsheet and in one of the columns is formatted for email
addresses and names like:

Bob Davis ([email protected])
James smith ([email protected])

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.
Click to expand...
 
Top