Convert Formula into text

  • Thread starter Thread starter Flamikey
  • Start date Start date
F

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
 
Nevermind.....I found the FORMULATEXT formula in the Morefunc Add-I
which works perfectly
 
One way would be to simply click on the cell and then enter an apostrophe
before the equal sign..........

Vaya con Dios,
Chuck, CABGx3
 
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
 
Back
Top