### How To Transform Data Calculated Via Formulas Into Static Values in Microsoft Excel

Suppose you have the following data: Num1 Num2 1 2 3 4 5 6 7 8 Then suppose you have another set of data which is as follows: Num3 Num4 =A2*2 =B2*2 =A3*2 =B3*2 =A4*2 =B4*2 =A5*2 =B5*2 Then, suppose you want to replace the data of the Num1 and Num2 with the results of […]