How to use Excel FORMULATEXT Function

how to use excel formulatext function

Quick Intro

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.

Examples For Excel FORMULATEXT Function

Sample File

download sample file to learn more about this tips

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.