How can I cause a cell to return the sheet name i.e. sheet 1?

M

Matt

I just want the cell to give the title of the sheet. For example: Sheet 1
would be displayed in A2 if A2 had this function.
 
P

Peo Sjoblom

One way

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,34)


you need to have saved the workbook
 

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

Excel - Wich Function should I use? 1
Vlookup and return sheet name also 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
copy cell range in other sheet 1
add hyperlink using sheet names and cells(i,j) 3
copy specific cells from sheets if the information is correct 3
Lookup Function help 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Top