ExcelBanter - How do I display the tab name in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I display the tab name in a formula (https://www.excelbanter.com/excel-worksheet-functions/35555-how-do-i-display-tab-name-formula.html)

Ian

How do I display the tab name in a formula

I have received a spreadsheet from another person and they have added a
formula that shows the "tab name" as the sheet title. This formula is
unfortunately in German and I am using an English version of excel so it does
not translate.

Can anyone help?

Anne Troy

Try this, Ian:
http://www.officearticles.com/excel/...ft_e xcel.htm
*******************
~Anne Troy

www.OfficeArticles.com

"Ian" wrote in message
...
I have received a spreadsheet from another person and they have added a
formula that shows the "tab name" as the sheet title. This formula is
unfortunately in German and I am using an English version of excel so it
does
not translate.

Can anyone help?

All times are GMT +1. The time now is 05:03 PM.