Learn how to use cell referencing in excel Function.

CELL

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)