Forum Discussion
Solved
remove a ' to convert a comment to a formula in excel
I routinely stick a ' in front of a formula to stop Excel from complaining/editing my text while I edit it to be the formula I want. Then I remove the ' to convert the cell back to a live forumula. ...
Hi lsmithop Select the range of cells and use Text to Columns on the Data tab. Select nothing in the wizard, just click Finish and it should convert them back to formulas.
Here is also my solution in addition to the wizard solution provided by Alan
1. Select all the values in column C and press CTRL + C top copy
2. Select all the values in column A such as '=C1, '=C2 etc
3. In the Paste dropdown, Paste Link (N)
You get the same result that Text to Column delivered...
1. Select all the values in column C and press CTRL + C top copy
2. Select all the values in column A such as '=C1, '=C2 etc
3. In the Paste dropdown, Paste Link (N)
You get the same result that Text to Column delivered...