Forum Discussion
Solved
Cell reference substitution.
I'm trying to create a cell of text of same or another cells address.
If I enter in cell C10 =cell("address",c10) I get as a result $C$10 as expected.
But I need the result to be the text C10 no $ signs.
I've tried "substitute"."$","") but I get errors.
I used to be really good with EXCEL but haven't used it the last few years and boy, am I rusty.
For sure, I'll be back here again!!
jgb
=ROW(INDIRECT(B32)) returns the row number of the cell whose address is in B32.
=COLUMN(INDIRECT(B32)) returns the column number of the cell whose address is in B32.
10 Replies
- Thank you,
I had actually tried that but must have had a typo. (old eyes!!!)
