How to display table name in a cell?

[JenniferMurphy]

What is the best way to display the name of a table in a cell outside the table? I was hoping for something like "=TableName(???)".

I found some complicated solutions online that either require a helper cell or VBA code.

Thanks

 

[arthurbr]

There is a UDF available at How to Show Excel Table Name on the Sheet - Contextures Blog

 

[JenniferMurphy]

There is a UDF available at How to Show Excel Table Name on the Sheet - Contextures Blog

Yeah, I saw that one or a similar one.

Here's a solution that requires a helper cell, but no VBA. In C4, I tried to merge the helper cell into the second expression, but that got an error. Not sure why???

It looks like there is a bug in xl2bb. It mistakenly reports the expression in G3 as also in C3 & K3.

Tables.xlsx
	B	C	D	E	F	G	H	I	J	K	L
3	Name	Table1			Name	Table3			Name	Table99
4		#N/A
5
6	Name	Len	Wid		Name	Len	Wid		Name	Len	Wid
7	A	25	10		A	25	10		A	25	10
8	B	30	25		B	30	25		B	30	25
9	C	15	10		C	15	10		C	15	10
10
11		"C3: =MID(FORMULATEXT(B3),2,FIND("[",FORMULATEXT(B3))-2)"
12		"G3: =MID(FORMULATEXT(F3),2,FIND("[",FORMULATEXT(F3))-2)"
13		"K3: =MID(FORMULATEXT(J3),2,FIND("[",FORMULATEXT(J3))-2)"
Table Name

Cell Formulas
Range	Formula
B3	B3	=Table1[[#Headers],[Name]]
F3	F3	=Table3[[#Headers],[Name]]
G3,C3,K3	G3	=MID(FORMULATEXT(F3),2,FIND("[",FORMULATEXT(F3))-2)
J3	J3	=Table99[[#Headers],[Name]]
C4	C4	=MID(FORMULATEXT(Table1[[#Headers],[Name]]),2,FIND("[",FORMULATEXT(Table1[[#Headers],[Name]]))-2)