Place the following formula in B2. Note your sheet must be saved or else you
will get a #VALUE! error.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

--
Regards,
Dave


"Jay" wrote:

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?

Thanks,