Maximizing Connectivity & Productivity

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 Excel Workbook, simply use;

=CELL(“filename”,A1)

The above formulas will only work in a Workbook that has been saved.

Thanks to Ozgrid

Leave a Reply

You must be logged in to post a comment.

E-mail: info@netlogistix.com
Mississauga, ON, Canada 905.607.3500