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 these formulas.

The Solution

All you need to do is highlight the data, Right Click it, and click the 123 Paste button (Labelled “Values”) to turn the data into values.

From there, you can copy and paste it below Num1 to get this:

Num1	Num2
2	4
6	8
10	12
14	16

Thanks for reading!