KRS Excel Articles
Excel – Using the CELL function
August 17, 2011
There are a number of useful options if you type =CELL( into excel.
Here’s a small selection of useful functions, including CELL, MID and FIND.
Typing “=CELL(“ in Excel will drop this menu down.
Most are self-explanatory, but there are some uses for CELL with filename that are “different”. For example, you can extract the sheet name from filename by using the MID function and looking for the square brackets after the filename.
First try =CELL(“filename”), to see what result you get.
To extract just the filename, with no path, try:
=MID(CELL(“filename”),1,FIND(“[",CELL("filename"))-1
To extract the current sheet name:
=MID(CELL("filename"),FIND("]“,CELL(“filename”))+1,255)
Bio: This article was written by Jasper Cook, Excel guru and trombonist of note. Call or email us if KRS can assist you with your Excel: enquiries@krs.co.za