On Thu, 30 Dec 2004 13:47:04 -0800, "Peo Sjoblom"
wrote:
However, if you Google for Longre, and/or morefunc.xll, you will find the
morefunc (free) add-in which contains a function called EVAL, which can convert
a formulaic string to it's result.
However, be sure that you are concatenating strings, and not a combination of
numbers and strings. So your formula would be something like:
=EVAL(CONCATENATE(TEXT(A1,"@"), B1, TEXT(C1,"@")))
or
=EVAL(TEXT(A1,"@")& B1 & TEXT(C1,"@"))
Actually this will work with number, operand, number
=EVAL(CONCATENATE(A1,B1,C1))
Regards,
Peo Sjoblom
Thanks for pointing that out. I had tried A1:C1 and got an error.
--ron
|