Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How I show, automatically, the tab name on a cell, in Excel?
0 views
Skip to first unread message
CPortilloTroconis
Feb 23, 2005, 2:31:04 PM2/23/05
to
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?
are; now the question is, is there any way to do it rather than copy & paste
it?
Thank you.
Sarah
Feb 23, 2005, 5:04:13 PM2/23/05
to
Try using the below formula-
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
CPortilloTroconis
Feb 24, 2005, 1:23:04 PM2/24/05
to
Thank very much for your help. Your formula did exactly what I meant!
Sarah
Feb 24, 2005, 1:36:10 PM2/24/05
to
Very glad I could help! I often come here for advice, and I'm glad I
can give back to the group!
can give back to the group!
Message has been deleted
0 new messages