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.