T

Description

T tests the supplied value and returns the value if it is text.

Syntax

T ( value )

 

Parameter

Description

value

The value to test.

Remarks

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

Examples

This function returns Report:

T("Report")

This function returns empty text (" ") if A4 contains a number:

T(A4)

Also, see

N

VALUE