how to copy contents of a cell and remove any brackets ( AND ) ?

J

jonny

Hi,

Does anyone out there know how to copy the contents of a cell to
another and remove any brackets that may be present, keeping the
bracketed word in the copied cell?

cheers,

Jon
 
N

Niek Otten

Hi Jon,

=SUBSTITUTE(SUBSTITUTE(A1,")",""),"(","")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| Does anyone out there know how to copy the contents of a cell to
| another and remove any brackets that may be present, keeping the
| bracketed word in the copied cell?
|
| cheers,
|
| Jon
|
 
J

JLatham

Not sure how you're copying the contents. If you've got a formula set up to
get the value like
=A1
where A1 has the text with brackets, then change to thi
=IF(ISERR(MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)),A1,MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1))

If you are just using copy and paste
then choose the cell(s) where you pasted the entry and use Edit | Replace to
Find [
Replace with (leave completely empty)
repeat for
Find ]
again, leave the 'replace with' portion completely empty.
 
J

jonny

Thanks Niek

Spot on that.. Do you know how to use this to remove "quotes" - it
just throws up an error when I replace the bracket ( with "

cheers,

Jon
 
N

Niek Otten

Hi Jon,

Excel HELP tells you to use two quotes within quotes to mean one quote
Excel's Help is often criticized, but really most of the basics are there

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Thanks Niek
|
| Spot on that.. Do you know how to use this to remove "quotes" - it
| just throws up an error when I replace the bracket ( with "
|
| cheers,
|
| Jon
|
|
| > Hi Jon,
| >
| > =SUBSTITUTE(SUBSTITUTE(A1,")",""),"(","")
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |
| > | Does anyone out there know how to copy the contents of a cell to
| > | another and remove any brackets that may be present, keeping the
| > | bracketed word in the copied cell?
| > |
| > | cheers,
| > |
| > | Jon
| > |
|
 
Top