VALUETOTEXT Function

Description

Returns text from any specified value.

NOTE

• For numeric data, the conversion result includes only raw values ​​(no formatting preserved).
• When using strict format, text values will be enclosed in double quotes (“”).

Syntax

Copied!=VALUETOTEXT(value, [format])
=VALUETOTEXT(value, [format])

EXAMPLE

Copied![𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘧𝘰𝘳𝘮𝘢𝘵=[0,1] - 𝘧𝘪𝘳𝘴𝘵 𝘷𝘢𝘭𝘶𝘦 𝘪𝘴 𝘥𝘦𝘧𝘢𝘶𝘭𝘵

//𝘊𝘰𝘯𝘷𝘦𝘳𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 ​​𝘧𝘳𝘰𝘮 𝘈1:𝘈10 𝘵𝘰 𝘵𝘦𝘹𝘵𝘴.
=VALUETOTEXT(A1:A10)
//𝘚𝘵𝘳𝘪𝘤𝘵 𝘧𝘰𝘳𝘮𝘢𝘵𝘵𝘪𝘯𝘨 𝘧𝘰𝘳 𝘢𝘳𝘳𝘢𝘺 𝘤𝘰𝘭𝘰𝘳 𝘯𝘢𝘮𝘦𝘴.
|-------|---------|--------|
| "red" | "green" | "blue" |
=VALUETOTEXT({"red", "green", "blue"}, 1)
[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭] 𝘧𝘰𝘳𝘮𝘢𝘵=[0,1] - 𝘧𝘪𝘳𝘴𝘵 𝘷𝘢𝘭𝘶𝘦 𝘪𝘴 𝘥𝘦𝘧𝘢𝘶𝘭𝘵

//𝘊𝘰𝘯𝘷𝘦𝘳𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 ​​𝘧𝘳𝘰𝘮 𝘈1:𝘈10 𝘵𝘰 𝘵𝘦𝘹𝘵𝘴.
=VALUETOTEXT(A1:A10)
//𝘚𝘵𝘳𝘪𝘤𝘵 𝘧𝘰𝘳𝘮𝘢𝘵𝘵𝘪𝘯𝘨 𝘧𝘰𝘳 𝘢𝘳𝘳𝘢𝘺 𝘤𝘰𝘭𝘰𝘳 𝘯𝘢𝘮𝘦𝘴.
|-------|---------|--------|
| "red" | "green" | "blue" |
=VALUETOTEXT({"red", "green", "blue"}, 1)

RELATED