How to get the formula in a cell
To get the formula in a cell, the FORMULATEXT function was introduced in Excel 2013.
It’s as simple as the following. Just reference the cell with the formula you’re interested in.
=FORMULATEXT(A1)
Need to do the same, but in older versions of Excel?
If you need to get the formula in a cell in Excel 2003, 2007 or 2010 you can use the pwrFORMULATEXT function. pwrFORUMLATEXT is available in an Excel addin you can download from the link below.
You use it the same way as the new function in 2013.
=pwrFORMULATEXT(A1)
Get the free addin
Overall, there are about 50 new worksheet functions in Excel 2013. The addin linked below adds 46 of the 50 functions so your legacy version of Excel can have most of the worksheet function capability of the 2013 version.
https://officepowerups.com/downloads/excel-powerups-premium-suite/
There you go.
Here are some related posts:
How to convert text to number values in Excel
How you can add the 50 New Functions in Excel 2013 to your old copy of Excel
Add Excel 2013 Functions to Excel 2010
Excel WEBSERVICE Function, plus ENCODEURL and FILTERXML Make a Useful Trio of Web Functions
How to use Excel to test a list of URLs or links to see if any are broken