I have a big spreadsheet (10k rows) that uses a formula that references values from other columns. To create the formula, I created a text and concatenated it to the values, then, brought that text to a new cell as paste values only. The result is the correct formula, but it is displaying the formula -not the result from it- until I go to each cell, press F2 and enter, then I get the value. Example:
a1 = 1
b1 = 1
c1 has the formula ="+a1+b1"
on d1 I pase values from c1.
Now d1 displays +a1+b1
On d1 I press f2 and enter,
Now d1 displays 2
How can I avoid the f2+enter and get the 2 directly?
thank you
a1 = 1
b1 = 1
c1 has the formula ="+a1+b1"
on d1 I pase values from c1.
Now d1 displays +a1+b1
On d1 I press f2 and enter,
Now d1 displays 2
How can I avoid the f2+enter and get the 2 directly?
thank you