How to display a sheet name in a cell:
- Location of the cell is B1
- Then the formula:
=MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255)
2018-01-18
Excel Excel - Display a sheet name in a cell -
* While I was organizing a audit file, there are over 55 samples need to group into one file. Want to get Excel to show the sheet name automatically in a cell so avoid to type the sample# for every sheet...*
How to display a sheet name in a cell:
- Location of the cell is B1
- Then the formula:
=MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255)
How to display a sheet name in a cell:
- Location of the cell is B1
- Then the formula:
=MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255)
