Excel CELL Function with Example

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.

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)