Excel – Using the CELL function

Here’s a small selection of useful functions, including CELL, MID and FIND.

Typing “=CELL(“ in Excel will drop this menu down.

cellfunction.png

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)

cell2.jpg

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.dev

 
0
Kudos
 
0
Kudos

Now read this

Excel: Dynamic Summing To-Date

Here is our example spreadsheet: The SUM formula in cell B15 is shown. It uses MONTH(NOW()), but could just as easily use a Named Formula: =SUM(OFFSET(Totals2009,0,0,ThisMonth,1)) Here’s the formula in Name Manager: How it works OFFSET’s... Continue →