Or (more robustly)
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL("filename",A1)))--David Biddulph"David Biddulph" <groups [at] biddulph.org.uk wrote in ... =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) "Al" wrote in ... Any way to import a tab name into a cell such that the cell text is thesame as the tab? (Tab name = Project ABC, and I'd like to automatically set cell B2 to "Project ABC") Allan