Formula in ASCII code

Is it possible to write a formula (working) in ASCII codes in formula bar? For example [=A1+B1] to work if I write say =Char(m)+Char(n) or whatever and this formula to be real and functional. Do I need some additional program or VB? Please help. Thanks in advanve

Ok. Sorry being unclear For Example if I write in cell B1 formula = A1 the value in A1 will be typed in B1. The same thing I want to do with ASCII. In ASCII =A1 is (as per my opinion) =CHAR(61)&CHAR(65)&CHAR(49). So, I would like to type the formula in this way, that means if I type similar expression in B1 (as formula) the value from A1 to be typed in B1. Onothere words-to substitute with ASCII codes, but to do the same work as =A1
Hope now the idea is is understood. Thanks again.

No, it won't work. Your formula will result in the string of text "=A1", but this will not be evaluated as a formula (the formula being the one with the CHARs in it). You would need another function to evaluate the resultant string as a formula. You could do this in B1:

Formula:

Please Login or Register  to view this content.

but that is limited in what it could do (you couldn't include operators or functions, for example).

In VBA there is an Evaluate function which will act upon a text expression which represents an Excel formula, so to use this in a worksheet you would need a UDF like this:

Please Login or Register  to view this content.

and then you could have this in B1:

Formula:

Please Login or Register  to view this content.

The expression could be much more complicated than this, like:

Formula:

Please Login or Register  to view this content.

where C1 and D1 contain numbers to define a range in column A to be summed, but I'm not sure why you would want to express it in ASCII code format anyway.

Hope this helps.

Pete

Thank you to all of you. I'll try all possibilities and will info