**Rational**

To display formula as text.

**Description**

The Excel FORMULATEXT function display the syntax of a reference cell as a string.

For example, Reference cell B5 contains the addition of two number =5+2 which return 7, **= FORMULATEXT(B5)** return a text value **“=5+2”**, not the result of the calculations.

**Syntax**

= FORMULATEXT(reference)

**Parameters**

**reference – **A reference to a cell or range of cells.

**Return Value**

The formula in text format.

**Key Notes**

The FORMULATEXT can be a great feature to highlight the cell that links to a given formula.

**Note** that formula is in a text format and cannot be part of any other calculation.

There are other options to display the formula in Excel:

- By using keyboard shortcut –
**Ctrl+`**(Windows) and**^+`**(Mac). This formula converts all formulas to text in a worksheet. - If you want to highlight only a single cell, at the start of formula we can enter an apostrophe (‘) or space “ “ to convert into text. Example
**‘=A23*(1+C$1)**is a text format and won’t return calculations.

**Example**

For example, If there is no formula it return #N/A (Not Available) like here in cell C8 (Result).

## Keep Reading Similar Functions:

### TRANSPOSE

The TRANSPOSE function “switch data direction” or the range of data from vertical format (row) to horizontal format (column), or vice versa.

### HYPERLINK

The HYPERLINK function creates a shortcut or clickable link of a given location with a “friendly name”. User Click that initiates a call for action.