Display sheet name in a cell

  • Thread starter Thread starter Paul
  • Start date Start date
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.
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
can a cell be both input and output? 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Cell names = sheet names 9
Tab Formula from diff sheets 1
sheet name in cell that is used by other formulas 3
Referencing formula using Indirect 4
add hyperlink using sheet names and cells(i,j) 3

Back
Top