Store sheet name in a cell on the sheet
 

This is what I am looking for.

I am also wanting to expand this one more step.
I would like to add some text to the end of this string.

Any ideas?

Thanks

"RagDyeR" wrote:

Enter this in any cell of an *already saved* sheet:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Trebor Retrac" <Trebor wrote in message
...
I wish to store the sheet name in a cell on the sheet.
I.E. Sheet Name is 14, Cell A2 to contain 14.
Using Excel 2000.

Store sheet name in a cell on the sheet
 

=Formula_You_Were_Given&" - Text in Here"

eg

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)&" - Text in
Here"

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Nicholas" wrote in message
...
This is what I am looking for.

I am also wanting to expand this one more step.
I would like to add some text to the end of this string.

Any ideas?

Thanks

"RagDyeR" wrote:

Enter this in any cell of an *already saved* sheet:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Trebor Retrac" <Trebor wrote in
message
...
I wish to store the sheet name in a cell on the sheet.
I.E. Sheet Name is 14, Cell A2 to contain 14.
Using Excel 2000.