=CELL ("contents",B3) returns the contents of B3. : Cell « Information functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Information functions
3. Cell

If the cell contains a formula, returns the result of the formula and not the formula itself.

Input the formula: =CELL ("contents",B3). Press Enter to get the result.

17.1.Cell
	17.1.1.	Cell function
	17.1.2.	=CELL ("address") returns the address of the last changed cell.
	17.1.3.	=CELL("color", B3) tells whether B3 is formatted for color-negative numbers
	17.1.4.	=CELL ("contents",B3) returns the contents of B3.
	17.1.5.	=CELL ("filename") returns the path, filename, and work sheet name of the workbook and worksheet
	17.1.6.	=CELL ("format",D1) returns a number format
	17.1.7.	=CELL ("parentheses", D2) returns 1 if a cell is formatted to have either positive values or all values displayed with parentheses.
	17.1.8.	=CELL("prefix", A1) returns the type of text alignment in a cell.
	17.1.9.	=CELL ("protect",A1) returns 1 if a protection is set to locked
	17.1.10.	=CELL("row", B6) returns the row number of the first cell in the range
	17.1.11.	=CELL("row", Summary) returns the row number of the first cell in the name
	17.1.12.	=CELL("type", A1) returns the type of information in a cell.
	17.1.13.	=CELL("width") returns the width of the last changed cell, rounded to an integer.
	17.1.14.	=CELL("width", A1) returns the width of A1