ExcelBanter - Worksheet tab name in cell

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Worksheet tab name in cell (https://www.excelbanter.com/excel-discussion-misc-queries/45295-worksheet-tab-name-cell.html)

Mark

Worksheet tab name in cell

I currently use both Excel 97 & Excel XP, is there a way by formula to
include the worksheet tab name in a cell similar to &[tab] in the
header/footer?
--
Mark

Gary''s Student

use:

=RIGHT(CELL("filename"),6)

but change the 6 to match the length of your tab name.

Have a good day
--
Gary''s Student

"Mark" wrote:

I currently use both Excel 97 & Excel XP, is there a way by formula to
include the worksheet tab name in a cell similar to &[tab] in the
header/footer?
--
Mark

Sandy

See
http://www.xldynamic.com/source/xld.xlFAQ0002.html
HTH

"Mark" wrote:

I currently use both Excel 97 & Excel XP, is there a way by formula to
include the worksheet tab name in a cell similar to &[tab] in the
header/footer?
--
Mark

Bob Phillips

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"Mark" wrote in message
...
I currently use both Excel 97 & Excel XP, is there a way by formula to
include the worksheet tab name in a cell similar to &[tab] in the
header/footer?
--
Mark

All times are GMT +1. The time now is 02:58 PM.