Formula to put Worksheet Name in a Cell

[DC Excel User]

I'd like to be able to include the name of each worksheet in the body
of the worksheet without having to type it in each time. Is there a
way to use a formula to tell Excel to do this. I've used
=cell("filename",a1) in the past to get the filename in the worksheet,
but I can't find a similar formula for the worksheet name itself.

Thanks.

 

[Guest]

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

 

[Bernard Liengme]

Gary might have mentioned the formula returns #VALUE! until you do a save
best wishes

 

[DC Excel User]

Gary might have mentioned the formula returns #VALUE! until you do a save
best wishes
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email






- Show quoted text -

Thank you. This worked perfectly -- I should have thought of this
solution.

 

[DC Excel User]

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

--
Gary''s Student - gsnu200721

I'd like to be able to include the name of each worksheet in the body
of the worksheet without having to type it in each time. Is there a
way to use a formula to tell Excel to do this. I've used
=cell("filename",a1) in the past to get the filename in the worksheet,
but I can't find a similar formula for the worksheet name itself.

Thanks.- Hide quoted text -

- Show quoted text -

Thank you so much. Perfect solution!