Copy and Paste a Formula from One Cell into Another
Select the cell that contains the formula you want.
To replace the entire formula, select the cell whose formula you want to replace.
To paste the formula into an existing formula, double-click the cell, and then click an insertion point where you want to paste the formula.
Press ENTER to accept the formula.