VALUETOTEXT
Returns text from any specified value.
TextModern Excel FunctionsText Processing
What it does
Converts any value to text (preserves format option).
Syntax
VALUETOTEXT(value, [format])
Arguments
value(value) — Value.format(number) — 0=Concise, 1=Strict (keeps quotes).
Examples
Value to Text
Convert 123 to string.
FORMULA
=VALUETOTEXT(123)
RESULT
123
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 123 |