How do I show the worksheet name in a cell?

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I tried using the formula =cell("filename"), but all worksheets shows the
same location in the cell. When F9 is pressed, it will update all the
worksheets to show the location of the worksheet I am working on.
 
Include the cell reference in your formula.

OR
Try the below for sheet name

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
 
Hi, I tried the =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"").
It's work perfectly.
Example my sheet name is actually a date(eg. 20 NOV 2009). On Cell A1 it will display the 20 NOV 2009, but how do i detect A1 the date "20 NOV 2009" is actually which day(MON,TUE,WED,THUR,FRI,SAT or SUN). anyway i can do to let it detect from A1 and let which day actually it is???





Jacob Skaria wrote:

Include the cell reference in your formula.ORTry the below for sheet
07-Oct-09

Include the cell reference in your formula

O
Try the below for sheet nam

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),""

If this post helps click Ye
--------------
Jacob Skari

:

Previous Posts In This Thread:

How do I show the worksheet name in a cell?
I tried using the formula =cell("filename"), but all worksheets shows th
same location in the cell. When F9 is pressed, it will update all th
worksheets to show the location of the worksheet I am working on.

Include the cell reference in your formula.ORTry the below for sheet
Include the cell reference in your formula

O
Try the below for sheet nam

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),""

If this post helps click Ye
--------------
Jacob Skari

:

EggHeadCafe - Software Developer Portal of Choice
..NET Anonymous Methods in C#
http://www.eggheadcafe.com/tutorial...9e-70fe23491470/net-anonymous-methods-in.aspx
 
What the formula returns is Text and not a real date.

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")*1

will return a real date which you can format to ddd


Gord Dibben MS Excel MVP
 
Back
Top