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

Trail Blazing by Francois Rossouw

What is Zurb Foundation? ZURB Foundation is a free collection of tools for creating websites and web applications. It contains HTML and CSS-based design templates for typography, forms, buttons, navigation and other interface components,... Continue →