Display sheet name in a cell

P

Paul

Is there an equivalent to =cell("filename",a1)which will
display the name of the Excel sheet in a cell?
Thanks for looking.
 
N

Norman Harker

Hi Paul!

You need to parse =CELL("filename",A1)

Use:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top