[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

T

Syntax:

T ( value )

Description: Retrieves the text represented by value.

Arguments:

Name

Type

Description

value

any

The value to be encoded in text. No conversion shall take place on an argument passed to this function.

 

Return Type and Value: text – value if value designates text; otherwise, "". [Note: T cannot differentiate between text that is an empty string, and any value of non-text type. end note]

[Example:

T("Hello") results in Hello
LEN(T(123)) results in 0
LEN(T(TRUE)) results in 0

end example]