Worksheet name in a cell

[Charlie]

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

[Duke Carey]

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)


"Charlie" wrote:

> 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

[Charlie]

Duke,

That is great! Many thanks and God bless.

Charlie

"Duke Carey" wrote:

> =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)
>
>
> "Charlie" wrote:
>
> > 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