excel cell value for sheet name code example Example: excel formula sheetname in cell =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)