FORMULATEXT function

Category: Lookup and reference
Introduced: Excel 2013

Summary

Returns the formula at the given reference as text

Syntax

FORMULATEXT(reference) The FORMULATEXT function syntax has the following arguments.
• Reference Required. A reference to a cell or range of cells.

Example

=TODAY()
=FORMULATEXT(A2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8

Back to Functions