Formula to remove certain character in a bracket

[dare2join]

hi all,

is there a way to remove certain character from below?
i have thousand of lines need to remove as long as it is in bracket "(xxxx)"

sample

result

i think this only involve some formulas without writing any Macro for it.
expert please help.
thanks.

[BadlySpelledBuoy]

Highlight the cells you need this change made in.
Press Ctrl+H to bring up the find and replace box.
In the top box enter (*)
Leave the bottom box blank and click "Replace All".

[hemesh]

assuming your data is in A1


try this in b1
=REPLACE(REPLACE(A1,FIND("(",A1),FIND(")",A1)+1-FIND("(",A1),""),FIND("(",REPLACE(A1,FIND("(",A1),FIND(")",A1)+1-FIND("(",A1),"")),FIND(")",REPLACE(A1,FIND("(",A1),FIND(")",A1)+1-FIND("(",A1),""))+1-FIND("(",REPLACE(A1,FIND("(",A1),FIND(")",A1)+1-FIND("(",A1),"")),"")

[xlbiznes]

try something like this :

Please Login or Register  to view this content.

[dare2join]

thanks a lot ! BadlySpelledBuoy
it is so so easy to replace all like this.

[BadlySpelledBuoy]

No problem. Sometimes the simplest solution just works.

BSB.

[millz]

I don't know how to do it with a formula, but this can be converted into a UDF.

Select the cells you need to remove the brackets and run this macro.

Please Login or Register  to view this content.

Edit: oh well, too, too slow.