How I show, automatically, the tab name on a cell, in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a column of cells showing the tab name of the sheet where they
are; now the question is, is there any way to do it rather than copy & paste
it?

Thank you.
 
Try using the below formula-

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
 
Thank very much for your help. Your formula did exactly what I meant!
Sarah said:
Try using the below formula-

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

I need to have a column of cells showing the tab name of the sheet where they
are; now the question is, is there any way to do it rather than copy & paste
it?

Thank you.
Click to expand...
Click to expand...
 
Very glad I could help! I often come here for advice, and I'm glad I
can give back to the group!
 
Very glad I could help! I often come here for advice, and I'm glad I
can give back to the group!
 
You must log in or register to reply here.

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

Reference the same cell based on tab name 1
How to get range names to Apply across multiple tabs 1
how can I make a cell content equal the tab name 'sheet1' ? 12
Autopopulate cell name with tab name 4
automatically change worksheet tab name 9
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Link to same cell in different sheets 4
Copy tab name to a cell or opposite 1

Back
Top