T function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• UPPER
• VALUE

< Previous Page

Next Page >

T

Returns the given text, or an empty text string if the target is not text.

Syntax:

T(value)

if value is text, it is returned.

if value is a number or a logical value, an empty text string "" is returned.

Example:

T("red car")

returns red car.

T(123.4)

returns an empty text string.

ISTEXT(T(123.4))

returns TRUE.

T(NA())

returns the #N/A error. Errors are propagated.

---

See Also

• TEXT
• N
• VALUE

• ISTEXT
• NA

• Text functions

• Functions listed alphabetically
• Functions listed by category