Worksheet Name

  • Thread starter Thread starter Greta
  • Start date Start date
G

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

Frank Kabel said:
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
Click to expand...
Click to expand...
 
Back
Top