Please help to Remove ( )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I need to remobe the "(" & ")" from several cells
ex.
(S) to
(XL) to X
(6) to
(12) to 1
I try several formuls like MID, LEFT, RIGHT, and REMPLACE but this ones teke only one character at time letme whit, XL) S) or somtingh like i need a formula to get rid off this brakets in one hit tanks
 
try SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")


Centauro said:
Hi I need to remobe the "(" & ")" from several cells
ex.
(S) to S
(XL) to XL
(6) to 6
(12) to 12
I try several formuls like MID, LEFT, RIGHT, and REMPLACE but this ones
teke only one character at time letme whit, XL) S) or somtingh like i need a
formula to get rid off this brakets in one hit tanks
 
Did you try selecting the range and pressing Ctrl+H?
Find what: (*)
Replace with: <leave this empty>

HTH
Jason
Atlanta, GA
-----Original Message-----
Hi I need to remobe the "(" & ")" from several cells
ex.
(S) to S
(XL) to XL
(6) to 6
(12) to 12
I try several formuls like MID, LEFT, RIGHT, and REMPLACE
but this ones teke only one character at time letme whit,
XL) S) or somtingh like i need a formula to get rid off
this brakets in one hit tanks
 
Select the data and Edit>Replace>(>Replace With>*leave blank*>OK
Repeat for the right parentheses.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Centauro said:
Hi I need to remobe the "(" & ")" from several cells
ex.
(S) to S
(XL) to XL
(6) to 6
(12) to 12
I try several formuls like MID, LEFT, RIGHT, and REMPLACE but this ones
teke only one character at time letme whit, XL) S) or somtingh like i need a
formula to get rid off this brakets in one hit tanks
 
Did you try selecting the range and pressing Ctrl+H?
Find what: (*)
Replace with: <leave this empty>

Did you try testing this gem? Why do you think this won't remove the parentheses
as well as everything between them?
 
Oops.
-----Original Message-----
...

Did you try testing this gem? Why do you think this won't remove the parentheses
as well as everything between them?

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
 
you could use edit replace on the menu bar
-----Original Message-----
Hi I need to remobe the "(" & ")" from several cells
ex.
(S) to S
(XL) to XL
(6) to 6
(12) to 12
I try several formuls like MID, LEFT, RIGHT, and REMPLACE
but this ones teke only one character at time letme whit,
XL) S) or somtingh like i need a formula to get rid off
this brakets in one hit tanks
 
Back
Top