CELL Function
Returns information about the formatting, location, or contents of a cell.
Category: Information
Location: Built-in
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.
Example
The following example uses the =CELL() function as part of a formula which extracts the filename.
