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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Move or Copy Stopped Working? 0
using the =page! feature to transpose a row to column 0
Update cell value based on name and specific date 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Hovering over a cell to show all data used in that cell 3
Vlookup and return sheet name also 2
code to unhide tabs based on cell contents 7

Back
Top