CELL
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.
Example
The following example uses the =CELL() function as part of a formula which extracts the filename.
=MID(CELL(“filename”),FIND(“[“,CELL(“filename”))+1,FIND(“]”,CELL(“filename”))-FIND(“[“,CELL(“filename”))-1)