Custom CELL Address to Field Value

jwuj97f - May 14, 2009 at 08:30 AM
 belo - Sep 15, 2009 at 05:47 AM
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.

got the following string

How can I convert / see the content of C28? I need to know how to convert the string value into its field value.


3 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 14, 2009 at 11:14 PM
Use =INDIRECT("C" & C3)
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
Thanks, the INDIRECT worked perfectly!

Again, Thanks,