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