Reed,

Use the following formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

The file must have been saved once in order to work. Do not
replace "filename" with the file name. Use the formula exactly as
written.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Reed" wrote in message
...
Is there a formula that will place the sheet name in a cell?

Thanks,

Reed