Re: Return Sheet Name?

Nick Fuller @ BFA wrote:
> Is there a way to return a sheetname in a cell?
>
> i.e ='sheetname'
>
> any help would be greatly appreciated.

On Sheet2, enter:

=CELL("address",'Sheet1'!A1)

You'll get 'Sheet1' as the first part of the result. Use some text string
commands to remove the extra stuff, and voila! Here's a sample command that
might work to remove your sheetname from the above result:

=MID(A1,SEARCH("]",A1,1)+1,SEARCH("'",A1,2)-SEARCH("]",A1,1)-1)

Note that this only works if your =CELL formula is on a different sheet than
the sheet of interest. The =MID command might be located anywhere.

Dave
dvt at psu dot edu