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.

  • lsmithop's avatar
    lsmithop
    Copper Contributor
    Jan 21, 2020

    Alan_MurrayHi Alan -- In case you are not old enough to remember Xerox' ad with Brother Dominic, here's a link: https://www.youtube.com/watch?v=LAt-lB9JIqw

    That's how I feel about your solution! It's like you reached into Excel and said "This is what Len needs..."

    Thank you 1,500 times!!

     

    Len

     

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

Resources