Convert a plus sign(or minus, mulitply and divide) in text format to operator.

[dominofly]

Hi All,

I need a little help please. Iv been racking my brain on this for a few hours now and still not able to get a workable solution.

Basically i have 3 cells in a row. a number in the first cell, in the second a + or - or, etc, and in the third i have another number. The problem is the cell containing the operator is in text format. Question is how do i convert that to back to an operator when i use all these cells in a formula. eg

5 + 5 = 10(this is where i would create my formula).

PS: i know to convert a number to a date it would be CDate(cell ref with number). Is there something like this that can work?

Thanks in advance!!
D

 

[njimack]

If you're happy using a UDF...

Function Eval(rng1 As Range, rng2 As Range, rng3 As Range)
    Eval = Evaluate(rng1 & rng2 & rng3)
End Function

=Eval(A1,B1,C1)

 

[dominofly]

thanks Neil!

I already know how to code it that way. Do you or anyone else know of a function that can do this without having to use VB script?

Thanks in advance!

D

 

[RoryA]

Define a name, say MyCalc, as:
=EVALUATE(Sheet1!$A$1&Sheet1!$B$1&Sheet1!$C$1)
and enter =MyCalc in the result cell. Then fill in the three referenced cells as needed.