add tab name to cell

[ammartino44]

Hello. How do I add tab name to a cell?

[quekbc]

Try this.

Please Login or Register  to view this content.

[Tony Valko]

=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))

If you don't include a cell reference (it can be to ANY cell) then that formula will return the sheet name of the last sheet that was active when a calculation was executed.

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Also of note, the file must have been saved and given a name before this formula will work.