Previous Topic Next Topic

Custom CELL Address to Field Value

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

3 responses

Answer 1 / 3
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)
4
Answer 2 / 3
belo
Sep 15, 2009 at 05:47 AM
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
Answer 3 / 3
jwuj97f
May 16, 2009 at 12:52 AM
Thanks, the INDIRECT worked perfectly!

Again, Thanks,
1

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Help with older moder HP Printer
Hlab -
hlabreche -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses