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)


CPortilloTroconis wrote:
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.

Thank very much for your help. Your formula did exactly what I meant!
"Sarah" wrote:

Try using the below formula-

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


CPortilloTroconis wrote:
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.

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!