A
adam
How do I make a cell only display the name of the sheet? without writing e.g
"sheet1"
Is there a formula such as =sheetname ?
"sheet1"
Is there a formula such as =sheetname ?
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.
S
Sheeloo
File must be saved at least once for the formula to work...
Try in any cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
Try in any cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
S
Sheeloo
File must be saved at least once for the formula to work...
Try in any cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
Try in any cell
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
A
adam
Brilliant works like a charm, thanks for your help!
A
adam
Brilliant works like a charm, thanks for your help!
S
Sheeloo
You are most welcome. Thanks for the feedback.
Try to get into the habit of using Google... it will save you time and teach
new things...
Try to get into the habit of using Google... it will save you time and teach
new things...
S
Sheeloo
You are most welcome. Thanks for the feedback.
Try to get into the habit of using Google... it will save you time and teach
new things...
Try to get into the habit of using Google... it will save you time and teach
new things...