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