software

I am attempting to get a cell to return the worksheet name. I am certain
there is a function that should do this, but I haven't found it. Any help is
appreciated.

Thanks,Charlie

=MID(CELL(quot;filenamequot;,$A$1),FIND(quot;]quot;,CELL(quot;filenamequot;,$A$1)) 1,100)quot;Charliequot; wrote:

gt; I am attempting to get a cell to return the worksheet name. I am certain
gt; there is a function that should do this, but I haven't found it. Any help is
gt; appreciated.
gt;
gt; Thanks,
gt;
gt;
gt; Charlie

Duke,

That is great! Many thanks and God bless.

Charlie

quot;Duke Careyquot; wrote:

gt; =MID(CELL(quot;filenamequot;,$A$1),FIND(quot;]quot;,CELL(quot;filenamequot;,$A$1)) 1,100)
gt;
gt;
gt; quot;Charliequot; wrote:
gt;
gt; gt; I am attempting to get a cell to return the worksheet name. I am certain
gt; gt; there is a function that should do this, but I haven't found it. Any help is
gt; gt; appreciated.
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt;
gt; gt; Charlie