Excel: T Function

In Excel, the T function returns the text referred to by a value.

The syntax for the T function is:

T( value )

value is the to extract the text from.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=T(A1) would return "Alphabet soup"

=T(A2) would return "techonthenet"

=T(A3) would return "34 hats"

=T(A4) would return ""

=T("56") would return "56"

=T(56) would return ""

=T(TRUE) would return ""