One way:

Name your cell, say "cell1"

then use: ADDRESS(ROW(cell1),COLUMN(cell1),4,TRUE)

In article ,
sam wrote:

Good morning €“

No amount of post searching turned up my answer, believe it or not.

I have a two-tab workbook. Tab one serves as a Table of Contents for
different locations on Tab 2.

On Tab 1, in one cell, I want to have text, and a specific cell address of
Tab 2.

Tab 1 example of the resulting display:

Calendar 2005 - Tab 2, D8

A couple of points.

1. D8 will move around on Tab 2, so the Tab 1 formula will have to €œtrack€�
it.
2. If possible, I dont necessarily want to display Tab 2 in the result,
just the cell
address.

I tried syntax along the lines of ="Calendar 2005 - "&ADDRESS(blah, blah),
but I just cant make this go€¦

Im stumped. Any takers?

Thanks to anyone who takes the time to respond. Ill keep an eye on the post.

Sam