data in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way or function in Excel 2000 to show the sheet tab's name in a cell on that sheet?
 
livi


Try the following formulas (work after you saved the workbook the first
time. Don't replace "filename" with anything, leave the formulas as
they are)

File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name only
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

Gord Dibben Excel MVP
 
Back
Top