• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

=FORMULATEXT()

bobhc

bobhc

Excel Ninja
The new =FORMULATEXT() in 2013 is going to save a lot of time, instead of copy/paste to display a formula as text with a single hyphen just enter the function and you get the formula as text and by wrapping it in ISFORMULA you can select a whole column and it will say whether there are or are not formulas in a column/row.

=IF(ISFORMULA(D1),FORMULATEXT(D1),"NO FORMULA")

Because it is a formula referencing a formula if the origanal changes so does the FORMULATEXT cell.
 
Hi Bob ,


You might have already done this , but just in case you haven't , there is more information in these links :


http://www.contextures.com/excelformulatextfunction.html


http://dailydoseofexcel.com/archives/2013/02/10/the-excel-formulatext-function/


Narayan
 
You must log in or register to reply here.
Back
Top