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;


Where A1 is any non error cell on the Worksheet. If you want the full path of the Excel Workbook, simply use;


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.

Mississauga, ON, Canada 905.607.3500