T

See also A-Z Spreadsheet Function List

Description Tests the supplied value and returns the value if it is text.

Syntax T(value)

value is the value to test.

Remarks Empty text ("") is returned for any value that is not text.

See Also N , and VALUE functions

Examples T(“Report”) returns “Report”

         T(A4) returns empty text ("") if A4 contains a number