Please do as follow to reference the active sheet tab name in a specific cell in Excel 1 Select a blank cell, copy and paste the formula =MID(CELL("filename",A1),FIND("",CELL("filename",A1))1,255) into the Formula Bar, and the press the Enter key See screenshot Now the sheet tab name is referenced in the cellComplete Excel Excel Training Course for Excel 97 Excel 03, only $ $5995 Instant Buy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE!=MID(CELL("filename",B1),FIND("",CELL("filename",B1))1,32) Watch the Video
Excel Formula List Sheet Names With Formula Exceljet
