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!
 
Top