CODEWITHSUNDEEP
google-sheetsexcel-formulagoogle-sheets-formula
Randy Sugianto 'Yuku'
Randy Sugianto 'Yuku'

Reputation: 73395

What is the function to return the name/address of a cell or range (Spreadsheet)?

I could not find the function that returns the name of the cell referenced. For example, =SOMETHING(A5) that will return A5 as string.

So that, I can write ="For more information, see " & SOMETHING(F50) & "." in a cell and the cell will read For more information, see F50., and then, when I move the F50 cell, the text will also change.

So, what is that SOMETHING?

If it works for Google Spreadsheet it's the best, but if you are not familiar with Google Spreadsheet, OpenOffice Calc and MS Excel solutions are most probably compatible too.

Upvotes: 0

Views: 14318

Answers (2)

Robert Mearns
Robert Mearns

Reputation: 11996

In Excel you can also use the CELL function.

="For more information, see " & CELL("address",F50) & "."

will return

For more information, see $F$50.

An alternate is to create a hyperlink to the location based on the CELL function. It will be easier for the end user, but the formula is more complex.

=HYPERLINK((MID(CELL("filename",F50),4,255)&"!"&CELL("address",F50)),"For more information click here.")

this will return 

For more information click here.

and when it is clicked on, the cell specified will be selected.

Upvotes: 1

dawntrader
dawntrader

Reputation: 785

In Excel you can use the ADDRESS function.

Upvotes: 2

Related Questions