Delete digits within brackets

Folks,

Need your favor to figure a way so that I can remove content within a bracket(includes). I am a newbie and have no knowledge on VB or functions in depth.

Eg. : Ironman shoots loki at the end of a cliff (100265)
I Need - " Ironman shoots loki at the end of a cliff " in its place
I have a 1000 fields across the sheet (includes blanks too) and I want to do the same for all at a single shot.

I tried the solutions provided in an old thread But it dint work for me.

Gives me 'Circular reference error' and when I click OK it gives me a 0-zero.

=REPLACE(A1,FIND(" (",A1),255,"") : This formula works only on a empty field rather than the field I use. Also, this allows me to work on one feild at a time, rather i want to apply on all sheets.http://www.excelforum.com/images/icons/icon9.png

Regards,

Bharat

I am still getting the same "Circular reference warning" and when i click OK the sentence become ZERO. I tried using the formula just beneath the sentence on a blank field and it works .

I need to replace the existing sentence with the rectified sentence in the same exact place.

Also, when i drag the formula field onto the other fields across the sheet, the sentences show "value" instead.

Please find the attachment.

Please find the attachment

Tab 1: Actual problem
Tab 2: Rectified Sheet

How did i rectify ?

I manually eliminated all the numbers in each field

Requirements :-

1. Remove brackets and data within
2. Change First digit of the numbering (e.g.: 4.X.X to 3.X.X )

Hi ambharat,
i have seen your file.

=IFERROR(LEFT(Current!A1,FIND("(",Current!A1,1)-1),"")

just paste this formula in your file Sheet3 and drag it to the used range.

is there any solution for my problem ??