Custom CELL Address to Field Value Closed

Question

Hello,
does anyone know how to convert a custom Cell Address to its field value in Excel?

I used Concatenate command to create Cell Address i.e.
=CONCATENATE("=","C",C3)

got the following string 
=C28

How can I convert / see the content of C28? I need to know how to convert the string value into its field value.

Thanks

Excelguru · Accepted Answer

Use =INDIRECT("C" & C3)

jwuj97f · Answer

Thanks, the INDIRECT worked perfectly!

Again, Thanks,

belo · Answer

hello i have dhe dd cell and mm cell and yyyy cells and i want to unit them in one cell in format dd/mm/yyyy how can i do in

Custom CELL Address to Field Value

3 responses

Similar discussions

Subscribe To Our Newsletter!