How to convert string to cell name in Excel?

W

wik8i2016-02-06 11:10:49

excel

wik8i, 2016-02-06 11:10:49

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

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

J

John Smith, 2016-02-07
@ClearAirTurbulence

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

E

excelok, 2017-01-07
@excelok

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