Worksheet tab name in cell

M

Mark

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?
 
G

Gary''s Student

use:

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

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

Have a good day
 
Top