Display cell address

boxsterman

Active Member
Joined
Apr 16, 2002
Messages
285
Hi all,

If I am in cell A1, how do I select cell C1 and have it displayed in the current cell. I don't want the value of the cell, I want the actual cell address - the value I want to show in cell A1 is the actual address "C1".

Thanks,

J
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
=SUBSTITUTE(CELL("address",$C$1),"$",)

which replaces the $ in the resulting text with nothing
 
Upvote 0
Nice solution, one in my haste I forgot about..

for clarification...

ADDRESS(row#, col#,abs)

Abs = reference returned 1 = absolute, 2 absolute row/relative column, 3 = absolute column, relative row , 4 = relative

a relative reference is without any $

an absolute reference is anchored by the $

to see the row and column #s go to TOOLS>OPTIONS>GENERAL and check the R1C1 check box... and the letters will show their numerical equivalent.

A1 reference style is Column-Letter, R1C1 reference is Row-Column reference..
 
Upvote 0
Of course it is, should I not have posted clarification for the OP?

If one was a not familiar enough with excel to know the answer to the question, I would not have known what the 1,3,4 meant in the formula....didn't mean to offend you or anything, just trying to be helpful to the OP, as you were, by explaining the syntax in your answer for the OP's benefit.
 
Upvote 0
If one was a not familiar enough with excel to know the answer to the question, I would not have known what the 1,3,4 meant in the formula

It is nice to have such, but OP should look at Help before he ask again. I think?
 
Upvote 0
True! But if he had, the question would not have been posed to begin with...anyways...I learn alot here, glad someone picked up my slack nonetheless
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top