I am working on a worksheet which has monthly payroll. I need to make a
macro which will go to the cell on the left, and remove a bracket in it
and a multiplication function in it.

For e.g. if A1 is =(221.86+1.15+3.75)*2, when i go to A2 I need the macro to
remove the brackets and the *2 so the result in A2 should be
=221.86+1.15+3.75. If I create the macro by keystrokes then wherever I am on
the workshet I get the same result as A1. So I need to use vb but dont have a
clue of the commands.

Any help will be sincerely appreciated.

Thankyou
MS