Constructing a Cell Reference from Char Functions?

[MEUserII]

I am trying to construct a cell reference from char functions; for example, if I want to reference the cell "A2" I would enter: ="A2"; which I could rewrite as: =INDIRECT("A"&2) ; which can be rewritten in char functions as: =INDIRECT( CHAR(34)&CHAR(85)&CHAR(34)&CHAR(50) ) ; where: "=CHAR(34), A=CHAR(85), and 2=CHAR(50).
However, this char function formula results in the "#REF!" error; how would I be able to successfully enter this formula with char functions?

 

[StephenCrump]

=INDIRECT(CHAR(65)&CHAR(50)) will return A2's value. Is that what you're after?

 

[Marcelo Branco]

A = CHAR(65), so try

=INDIRECT(CHAR(65)&CHAR(50))

M.