How do I show the worksheet name in a cell?

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

Jacob Skaria

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
 
H

HONG YONG TAN

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
 
G

Gord Dibben

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
 

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

Sheet Names and Auto-calculation 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA 1
Excel formula for an "if" "then" scenario linking 3 worksheets 2
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
How do I lookup data from multiple worksheets? 2
Global name used in local version 3
Function to put worksheet name in cell returns text, need number 5

Top