FORMULATEXT Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

FORMULATEXT is an Excel Lookup & Reference function. Returns a formula as text, so you can see it displayed in another cell.

FORMULATEXT syntax

=FORMULATEXT(reference)

FORMULATEXT is used to pull matching data from one part of a workbook into another.

Open the live Excel-style spreadsheet and try FORMULATEXT yourself. No Excel install or sign-up needed to start.

What does the FORMULATEXT function do in Excel?

Returns a formula as text, so you can see it displayed in another cell.

What is the syntax of FORMULATEXT in Excel?

The syntax is =FORMULATEXT(reference). reference: The cell or range being referenced.

Where can I practice FORMULATEXT online for free?

Open the free live spreadsheet on Cellgrids and try FORMULATEXT yourself. No Excel install is needed and you can start without signing up.