View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
DC Excel User DC Excel User is offline
external usenet poster
 
Posts: 3
Default 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!