Hi there!
I'd like to use the name of a table (e.g. "January") in a formula to make it appear in a certain cell.
How can this be accomplished?
I managed to get the table's number using "TABELLE()" but the number is not what I need, I need the name.
Couldn't find that function in the help.
Thanks in advance!
UdoMM
:
<><
Calc: How to use the table name in a formula?
Re: Calc: How to use the table name in a formula?
=MID(CELL("filename");FIND("#$";CELL("filename"))+2;LEN(CELL("filename")))
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice