software

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

quot;RagDyeRquot; wrote:

gt; Enter this in any cell of an *already saved* sheet:
gt;
gt; =MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt;
gt; quot;Trebor Retracquot; lt;Trebor gt; wrote in message
gt; ...
gt; I wish to store the sheet name in a cell on the sheet.
gt; I.E. Sheet Name is 14, Cell A2 to contain 14.
gt; Using Excel 2000.
gt;
gt;
gt;

=Formula_You_Were_Givenamp;quot; - Text in Herequot;

eg

=MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)amp;quot; - Text in
Herequot;

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

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
quot;Nicholasquot; gt; wrote in message
...
gt; This is what I am looking for.
gt;
gt; I am also wanting to expand this one more step.
gt; I would like to add some text to the end of this string.
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt; quot;RagDyeRquot; wrote:
gt;
gt;gt; Enter this in any cell of an *already saved* sheet:
gt;gt;
gt;gt; =MID(CELL(quot;Filenamequot;,A1),FIND(quot;]quot;,CELL(quot;Filenamequot;,A1)) 1,255)
gt;gt; --
gt;gt;
gt;gt; HTH,
gt;gt;
gt;gt; RD
gt;gt; ==============================================
gt;gt; Please keep all correspondence within the Group, so all may benefit!
gt;gt; ==============================================
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Trebor Retracquot; lt;Trebor gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; I wish to store the sheet name in a cell on the sheet.
gt;gt; I.E. Sheet Name is 14, Cell A2 to contain 14.
gt;gt; Using Excel 2000.
gt;gt;
gt;gt;
gt;gt;