How to extract the formula text in Excel

Auditing and troubleshooting formulas in Microsoft® Excel® can be time consuming and difficult. That is why the FORMULATEXT function is helpful because it simplifies formulae error checking and correction. The formula text can easily be extracted without having to copy and paste.

The FORMULATEXT function syntax has one required input—a reference to a cell or range of cells. The reference can be to another worksheet or open workbook.

You are welcome to download the workbook to practice.

Applies To: Microsoft® Excel® 2010, 2013 and 2016.

1. Select cell C16 and enter the formula =FORMULATEXT(F3).

2. The formula text will be displayed in cell F3 and you can then make corrections or audit the formula.

image-1

The formula text has been extracted and it will be easy to make corrections or audit the formula.