Wednesday, March 14, 2012


Excel Function To Return The Name of the Worksheet

One of Excel's most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data.

Excel's CELL function comes close. The following formula displays the workbook's full path along with the worksheet name:


For example, this formula might return something like:

Excel Function To Return The Name of the Worksheet


Returning only the sheet name requires a more complex formula:

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


About bench3 -

Haja Peer Mohamed H, Software Engineer by profession, Author, Founder and CEO of "bench3" you can connect with me on Twitter , Facebook and also onGoogle+

Subscribe to this Blog via Email :