Hello sdmccabe,

Type the following formula:

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

Exactly as is written but on 1 line

Judith
--
Hope this helps


"sdmccabe" wrote:

Can I display the name of a tab in a given cell?