Excel Batch substitution formula for the ACE

In the cells of Excel, we can use formulas.

If you want to bulk replace the formulas for Excel cells, you cannot do this by using the normal find and replace feature. You have to use the following. Trick.

Look at the following table, for example, the formula in column C is:

C1=a1+b1

C2=a2+b2

C3=a3+b3

C4=a4+b4

C5=a5+b5

Now we're going to replace these formulas with the following:

c1=sheet2! a1+sheet2! B1

c2=sheet2! a2+sheet2! B2

c3=sheet2! a3+sheet2! B3

c4=sheet2! a4+sheet2! B4

c5=sheet2! a5+sheet2! B5

The method is as follows, first, find the menu "tools" → "options", pop up the following image.

In the diagram above, switch to the View tab, find formula, and precede it with √. Click "OK" to confirm the exit.

Then, select Menu "edit" → "replace" and pop up the following image.

Enter a in the lookup content, in the replacement for the inside input sheet2! A, then, click "Replace All".

Now it's time to replace the other.

Computer Tutorials

Again, "edit" → "replace", in the figure above, find content input B, replace with input sheet2! B, so, all are replaced, this is the method of batch substitution formula.

Notice that after the replacement, in figure one, you have to remove the √ in front of the formula, otherwise your formula will not be counted.