converting text to a formula

W

West

is it possible to convert a text string to a formula?

I have built a series of cells using CONCATENATE to produce a text
string for a vlookup formula - is there a way to now use this text as a
working VLOOKUP formula?

Thanks.
West.
 
B

BenjieLop

West said:
is it possible to convert a text string to a formula?

I have built a series of cells using CONCATENATE to produce a tex
string for a vlookup formula - is there a way to now use this text as
working VLOOKUP formula?

Thanks.
West.
Click to expand...

Placing the equal sign ( = ) before the string is a good start i
developing a formula
 
D

Dave Peterson

And if you mean manually, just
select your range
edit|copy and edit|paste special|Values
then
edit|replace
what: = (equal sign)
with: = (equal sign)

A small hint. If you point to another worksheet or workbook, make sure you do
it for a couple of cells first.

If you've mistyped a worksheet name 700 times, you'll have to dismiss a dialog
700 times (or kill excel).

So add "Save your workbook first" to the top of the list of instructions--just
in case!
 
Top