|
|
| Next: address and return address on back of letter |
| Author |
Message |
Sam
External
Since: Oct 03, 2004
Posts: 270
|
 Posted: Wed Oct 07, 2009 7:00 pm Post subject: How do I show the worksheet name in a cell?
Archived from groups: microsoft>public>excel>misc (more info?) |
|
|
|
| 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.
|
|
|
| Back to top |
|
 |
Jacob Skaria
External
Since: Mar 04, 2009
Posts: 442
|
Posted: Wed Oct 07, 2009 7:06 pm Post subject: RE: How do I show the worksheet name in a cell? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
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
---------------
Jacob Skaria
"Sam" wrote:
> 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. |
|
| Back to top |
|
|
HONG YONG TAN
External
Since: Nov 03, 2009
Posts: 1
|
Posted: Tue Nov 03, 2009 7:31 am Post subject: Display [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
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.
OR
Try the below for sheet name
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")
If this post helps click Yes
---------------
Jacob Skaria
"Sam" wrote:
Previous Posts In This Thread:
On Wednesday, October 07, 2009 10:00 PM
Sam wrote:
How do I show the worksheet name in a cell?
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.
On Wednesday, October 07, 2009 10:06 PM
Jacob Skaria wrote:
Include the cell reference in your formula.ORTry the below for sheet
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
---------------
Jacob Skaria
"Sam" wrote:
EggHeadCafe - Software Developer Portal of Choice
..NET Anonymous Methods in C#
http://www.eggheadcafe.com/tutorials/aspnet/959a2934-088c-4401-ac9e-70...3491470 |
|
| Back to top |
|
|
Gord Dibben
External
Since: Feb 23, 2004
Posts: 9179
|
Posted: Tue Nov 03, 2009 9:12 am Post subject: Re: Display [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
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
On Tue, 03 Nov 2009 07:31:27 -0800, HONG YONG TAN wrote:
>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.
>
>OR
>Try the below for sheet name
>
>=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")
>
>If this post helps click Yes
>---------------
>Jacob Skaria
>
>
>"Sam" wrote:
>
>Previous Posts In This Thread:
>
>On Wednesday, October 07, 2009 10:00 PM
>Sam wrote:
>
>How do I show the worksheet name in a cell?
>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.
>
>On Wednesday, October 07, 2009 10:06 PM
>Jacob Skaria wrote:
>
>Include the cell reference in your formula.ORTry the below for sheet
>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
>---------------
>Jacob Skaria
>
>
>"Sam" wrote:
>
>EggHeadCafe - Software Developer Portal of Choice
>.NET Anonymous Methods in C#
>http://www.eggheadcafe.com/tutorials/aspnet/959a2934-088c-4401-ac9e-70fe23491470/net-anonymous-methods-in.aspx |
|
| Back to top |
|
|
|
|
Microsoft Office