## 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.

## 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.

Patty B28 Aug, 18 at 6:56 pmThis is so Cool!!! Never seen it before

MoniqueB28 Aug, 18 at 4:49 pmHave no idea how I would use this, but I love it