Delete digits within brackets

Yes it worked ..in the sample document. My original document is restricted access where i can only edit and save. Used your formula in a new sheet and it gives me a pop-up "update values current" and asks me to select a file. Also please design something i can attack column wise in the actual sheet.

Pls look into my second requirement too.. changing numbering.Refer rectified tab.