Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows  ¨  Free Downloads

Return the Worksheet Name to a Cell in Microsoft Excel

Tip: In the formulas below, "filename" is exactly what you type, it's not something that means you're supposed to type your file name.

• Type the following formula into the cell where you want the worksheet name to appear:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

• Use the following formula to get the entire path, workbook name, and sheet name

=CELL("filename",A1)

All contents copyright Anne Troy 2005-2006