Forum Discussion
Solved
Paste formulas not working
If I copy a value that has been generated by a formula in Excel and paste into a different cell and then try to convert the value in the cell to appear as a formula by using the available methods, it...
- It sounds like you want to paste the formula text?
If you have the formulatext function, you could use it to reference the cell containing the formula:
=FormulaText(A1)
Alternatively, you could try formatting the cell as text and the copy paste the formula from the formula bar to the destination cell.
If my understanding of what you're trying to do is correct, then the paste special-formula behavior is not a bug as it has always pasted in the formula as an expression to be evaluated.
Hi JMB17
I have the same issue except I am using multiple cells in a grid.
Would you be able to offer some advice.
Kindly
Peter
Find "=" in the column or area with your formulas, Replace with an apostrophe ' before the = sign, like this: '= then formulas will be visible and can be copy-pasted. Once done, Find '= and Replace with =.