Formula to put Worksheet Name in a Cell
On May 12, 2:20 pm, Gary''s Student
wrote:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
--
Gary''s Student - gsnu200721
"DC Excel User" wrote:
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!
|