G
GregR
How do I get the sheet name in a cell. TIA
Greg
Greg
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
P
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
you can put this formula in any cell, even A1
Regards,
Peo Sjoblom
G
GregR
JE and Peo, thank you very much.
Greg
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