Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan
R Ruan Sep 17, 2004 #1 Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan
A Alan Sep 17, 2004 #2 Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan Click to expand... Hi Ruan, Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) HTH, Alan.
Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan Click to expand... Hi Ruan, Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) HTH, Alan.
R Ruan Sep 17, 2004 #3 Thanks Alan. That works great. Ruan Alan said: Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan Click to expand... Hi Ruan, Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) HTH, Alan. Click to expand...
Thanks Alan. That works great. Ruan Alan said: Hello, Is there a formula that will display the Sheet name in a cell? Thanks Ruan Click to expand... Hi Ruan, Try this: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) HTH, Alan. Click to expand...
