Maximizing Connectivity & Productivity

Archive for March 15, 2012

Return a Worksheet name to a cell

 In Excel, use the CELL function/formula and the MID and FIND to return the name of an Excel Worksheet in a Workbook. The formula below shows us how; =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,256) Where A1 is any non error cell on the Worksheet. If you want the full path of the […]

Read more
Mississauga, ON, Canada 905.607.3500