Forum Discussion

lsmithop's avatar
lsmithop
Copper Contributor
Jan 20, 2020
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. ...
Formulas and Functions
  • Alan_Murray's avatar
    Alan_Murray
    Jan 20, 2020

    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.

Alan_Murray's avatar
Alan_Murray
MVP
Jan 20, 2020

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.

Abiola1's avatar
Abiola1
MVP
Jan 20, 2020
Whaooo... That's cool trick! 😀👍

Resources