t

Return text values unchanged; non-text values become empty.

Syntax

v = t(value)

Description

If value is text, returns it unchanged. If it’s any other type (number, logical, etc.), returns an empty string. Used in Excel formulas to coerce mixed-type cells.

Examples

t('hello')              % 'hello'
t(42)                   % ''

See also

• n — Convert a value to a number; non-numeric becomes 0.
• value — Convert a text string to a number.