### [Solved] Display cell name

Posted:

**Sat Jun 11, 2016 12:05 am**I would like to show the cell names I "defined" in referenced cells. Something like the FORMULA() function.

For example: A1<--$11.00, A2<--$22.00 and A3<--=SUM(A1:A2) showing "$33.00".

Now -- with cell A3 selected, I do: "Insert - Names - Define. The Define Names (Ctrl+F3)"

... and enter "line20a"

(Note that when cell A3 is selected by itself, "line20a" shows in the range box.)

(Note that when 4 cells are selected A3,A4,B3 & B4, "A3:B4" shows in the range box)

In cell B6, I enter the formula =line20a, now it shows "$33.00".

If I enter =FORMULA(B6) in B7, it shows "=line20a".

Is there a function like CELLNAME(A3), that I could enter in B5, for example,

that would show "line20a" ?

For example: A1<--$11.00, A2<--$22.00 and A3<--=SUM(A1:A2) showing "$33.00".

Now -- with cell A3 selected, I do: "Insert - Names - Define. The Define Names (Ctrl+F3)"

... and enter "line20a"

(Note that when cell A3 is selected by itself, "line20a" shows in the range box.)

(Note that when 4 cells are selected A3,A4,B3 & B4, "A3:B4" shows in the range box)

In cell B6, I enter the formula =line20a, now it shows "$33.00".

If I enter =FORMULA(B6) in B7, it shows "=line20a".

Is there a function like CELLNAME(A3), that I could enter in B5, for example,

that would show "line20a" ?