B Bob Phillips Feb 10, 2004 #2 Gerry, You mean the tab name in a cell? =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Gerry, You mean the tab name in a cell? =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
