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.