Worksheet Name

[Greta]

How do you insert the worksheet name into the worksheet?
I have 80 worksheets and need the name of each to appear
on the sheet. Is there a simple formula for that?
Thanks,
Greta

 

[Frank Kabel]

hi Greta
try the following formula for the sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

Frank

 

[JE McGimpsey]

A couple fewer function calls, but along the same lines:

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

where 255 is just a big number.

hi Greta
try the following formula for the sheet name
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

Frank

How do you insert the worksheet name into the worksheet?
I have 80 worksheets and need the name of each to appear
on the sheet. Is there a simple formula for that?
Thanks,
Greta