Formula to put Worksheet Name in a Cell
 

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.

Formula to put Worksheet Name in a Cell
 

=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.

Formula to put Worksheet Name in a Cell
 

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

"DC Excel User" wrote in message
ups.com...
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.

Formula to put Worksheet Name in a Cell
 

On May 12, 2:45 pm, "Bernard Liengme"
wrote:
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

"DC Excel User" wrote in oglegroups.com...



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. This worked perfectly -- I should have thought of this
solution.

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!