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

The Agile Business Analyst

The role of a Business Analyst in software development is a topic often ignored in Agile projects. While I fully support iterative development and embracing change in regard to creating specifications, I acknowledge that the need for... Continue →