Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

FORMULATEXT

To display formula as text in Excel
Returns the formula at the given reference as text

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:

Switch reference data from rows to columns or vice versa in Excel

TRANSPOSE

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

Read More »
Create a shortcut of a given path in Excel

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.

Read More »