Autopopulate cell name with tab name
Must have a cell reference included or each sheet will have same name
returned.
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),)
Gord Dibben MS Excel MVP
On Fri, 5 Jun 2009 11:10:07 -0700, Shane Devenshire
wrote:
Hi,
Try:
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,31)
or shorten Jacob's suggestion to
=REPLACE(CELL("Filename"),1,FIND("]",CELL("filename")),)
|