Custom CELL Address to Field Value

[Closed]
Report
-
 belo -
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

3 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Use =INDIRECT("C" & C3)
4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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
4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thanks, the INDIRECT worked perfectly!

Again, Thanks,