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

C

CPortilloTroconis

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.
 
S

Sarah

Try using the below formula-

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

CPortilloTroconis

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...
 
S

Sarah

Very glad I could help! I often come here for advice, and I'm glad I
can give back to the group!
 
S

Sarah

Very glad I could help! I often come here for advice, and I'm glad I
can give back to the group!
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Merging from an Excel file with graphics 1
Cell data entering slow! 0
How to set tabs in work document 0
Paste to excel from word - auto format problem 1
Excel does not accept text format! 0
Cells not updated automatically 3
Copy addition formula of non-consecutive horizontal cells 2

Top