Use Excel FORMULATEXT Function to get a formula from a cell as a text string.

In simple words, when you refer to a cell which contains a formula, it will return that formula from the cell, like which is displayed in the formula bar if you select that referred cell.

Syntax

FORMULATEXT(reference)

reference A cell reference from which you want formula as a text.

More Information on Excel FORMULATEXT Function

You can refer to another workbook & another worksheet.

If you refer to another workbook that workbook should be open, otherwise it will not show the formula.

If you refer to a range more than a single cell, it will return formula from the upper left cell of the given range.

It will return an “#N/A” error value if the cell you are using as a reference does not contain any formula, has a formula with more than 8192 characters, a cell is protected or an external workbook is not opened.

If you refer two cells in circular reference it will return result from both.

Example

In the below example, I have used formula text with a different type of references. When you refer to a cell which doesn’t have any formula, it will return “#N/A” error value.

Sample File

What’s Next?

To learn more about Excel FORMULATEXT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have LEN function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.