Extract current (Active) workbook name

I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with no extension =MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-6) So, here it is….   And if we want to go 1 step further, I often have the version of the tool as part of the filename, […]

Get column name (columnname as A,B,C, etc) as input inside cell

Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if you add no parameters However, the COLUMN() is kind of tricky Because of the fact that cell addresses (or references) are based on the old style of R1C1 =Column()