=CELL("filename") function related question

Is there a function in Excel that only picks up the sheet name in a
workbook? I realised that =CELL("filename") function provides the full
path, workbook & the worksheet information.
Thanks in advance for any help & suggestions.

Take a look here:

http://www.mcgimpsey.com/excel/formu..._function.html


In article <[email protected]>,
"wfcpyc" <[email protected]> wrote:

> Is there a function in Excel that only picks up the sheet name in a
> workbook? I realised that =CELL("filename") function provides the full
> path, workbook & the worksheet information.
> Thanks in advance for any help & suggestions.

Thanks heaps JE ..............