VALUETOTEXT
Returns text from any specified value
Syntax
VALUETOTEXT(value, [format])
Parameters
- value: Required. The value to return as text
- format: Optional. 0=concise format (default), 1=strict format with escape characters
Example
=VALUETOTEXT(A1, 0)