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.