Excel provides a quick way to apply a mathematical operation on a range of cells. Youd better use VBA to solve your task. Press Replace All button.
For multiplication the formula is mainly the same as subtraction.
Click the OK button and then the Close button. In the Operation Tools dialog click Custom in the Operation section and type the formula into the text box you can. Click the OK button and then the Close button. Excel provides a quick way to apply a mathematical operation on a range of cells.