J JE McGimpsey Dec 22, 2004 #2 Take a look here: http://www.mcgimpsey.com/excel/formulae/cell_function.html
G Guest Dec 22, 2004 #3 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) you can put this formula in any cell, even A1 Regards, Peo Sjoblom
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) you can put this formula in any cell, even A1 Regards, Peo Sjoblom
G GregR Dec 22, 2004 #4 JE and Peo, thank you very much. Greg Peo Sjoblom said: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) you can put this formula in any cell, even A1 Regards, Peo Sjoblom GregR said: How do I get the sheet name in a cell. TIA Greg Click to expand... Click to expand...
JE and Peo, thank you very much. Greg Peo Sjoblom said: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34) you can put this formula in any cell, even A1 Regards, Peo Sjoblom GregR said: How do I get the sheet name in a cell. TIA Greg Click to expand... Click to expand...
