Retrieving Cell name in Excel

Question

Is there a way of displaying the cell name of a particular cell in another cell? I would like to display the cell name in the adjacent cell so that the user is able to identify the cell name without clicking it.

Answer 1

ADDRESS(ROW(),COLUMN()) returns the current cell's address, such as $A$1. To reference the cell you want, add/subtract from the row/column values (numbers).

If you don't want the $, you may search for it and substitute it with SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$","") to get simply A1.