### T Function - Simply genius or complete waste of code?

I wanted to take some time today to review an often overlooked function.

The T function checks the value in a cell and if the value is text, it returns the text value. If it is not a text value, the T function returns double quotes (empty text).

There is only one argument in the T function (the cell reference) =T(cell reference).

In the below example I have in column A different types of formats (text, percentages, numbers and dates). I have placed the T function in column C and you can clearly see how this works.

 A C D E 1 Item Result Formula Explanation 2 one one =T(A2) this is a text so the result is the text value in cell A2 3 15% =T(A3) this is a percent so the result is double quotes 4 three three =T(A4) this is a text so the result is the text value in cell A4 5 4 =T(A5) this is a number so the result is double quotes 6 6/15/2012 =T(A6) this is a date so the result is double quotes

So what can the T function do for you?