Is there any way to display the Formula of another individual cell (not all
cells on the Worksheet as per using Tools / Options / View then selecting
Formulas Check box) using Standard Excel functions (not macros).

ie if Cell A1 has formula =A2+1 want to create a method of displaying the
formula (as text) in another Cell

Trying to avoid Macros but could do this easily by creating a VB Function like

Public Function TextFormula(rngFormula As Range) As String

TextFormula = rngFormula.Formula

End Function

Then having in the other Cell =TextFormula(A1)