View Single Post
  #7   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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