How to convert string to cell name in Excel?

Question

excel

How to convert string to cell name in Excel?
Example:
The value is generated using =CONCATINATE("A"; 1)
How to tell the cell value to become not the string "A1" but the value of the field A1

Answer 1

=INDIRECT(CONCATENATE("A",1))

Answer 2

and if the Excel is in Russian (including functions, then the same formula will be like this):
= INDIRECT (CONCATENATE (("A"; 1))
this formula will return the value of cell A1, that is, what is entered in it, then will be the result of this formula