Search

Learn how to use cell referencing in excel Function.

CELL

excel cell reference
What Does It Do ?
This function examines a cell and displays information about the contents, position and formatting.
Syntax
‘=CELL(“TypeOfInfoRequired”,CellToTest)
The TypeOfInfoRequired is a text entry which must be surrounded with quotes ” “.
Formatting
No special formatting is needed.
Codes used to show the formatting of the cell.
what is cell references in excel
Example
The following example uses the =CELL() function as part of a formula which extracts the filename.
 
excel formula cell
 
 =MID(CELL(“filename”),FIND(“[“,CELL(“filename”))+1,FIND(“]”,CELL(“filename”))-FIND(“[“,CELL(“filename”))-1)
Share this article :
Facebook
Twitter
LinkedIn

Leave a Reply