FORMULATEXT to show formulas

Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a certain cell
Not any more

Excel 2013 (Excel 365 or Excel 2016) comes with the new formula FORMULATEXT()

This beautiful one, just shows the formula from a cell.

Get it from Sheet2 in attached spreadsheet



Related posts