Convert Formula into text

[Flamikey]

This should be an easy one.......What is the easiest way to conver
formula agruments into text? Example:

In cell A1 there is the following formula:

=VLOOKUP(F1,G:H,2,False)

I want cell B1 to be a text string of the formula in A1 so it would be
"=VLOOKUP(F1,G:H,2,False)"

Thank

 

[Flamikey]

Nevermind.....I found the FORMULATEXT formula in the Morefunc Add-I
which works perfectly

 

[CLR]

One way would be to simply click on the cell and then enter an apostrophe
before the equal sign..........

Vaya con Dios,
Chuck, CABGx3

 

[Flamikey]

True,
But I actually have about 6000 rows beneath where I needed to do th
same thing. Instead of going into A1, inserting the ', copying into B
and then going back to A1 and removing the ' (I wanted to retain th
original formula), and doing this for 6000 rows, the FORMULATEX
function did it in about 5 seconds

 

[CLR]

Thats cool...........I just wanted to offer another solution............Edit

Replace...could do it quickly as well..........

Vaya con Dios,
Chuck, CABGx3