VALUETOTEXT function
Summary
Returns text from any specified value
Syntax
VALUETOTEXT(value, [format])
The VALUETOTEXT function syntax has the following arguments.
value | The value to return as text. Required.
format | The format of the returned data. Optional. It can be one of two values: 0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied. 1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.
Note: If format is anything other than 0 or 1, VALUETOTEXT returns the #VALUE! error value.
value | The value to return as text. Required.
format | The format of the returned data. Optional. It can be one of two values: 0 Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied. 1 Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.
Note: If format is anything other than 0 or 1, VALUETOTEXT returns the #VALUE! error value.
Example
=VALUETOTEXT(A2, 0)
=VALUETOTEXT(A2, 1)
=VALUETOTEXT(A3, 0)
=VALUETOTEXT(A3, 1)
=VALUETOTEXT(A4, 0)
=VALUETOTEXT(A4, 1)
=VALUETOTEXT(A5, 0)
=VALUETOTEXT(A5, 1)
=VALUETOTEXT(A6, 0)
=VALUETOTEXT(A6, 1)
=VALUETOTEXT(A7, 0)
=VALUETOTEXT(A7, 1)
=VALUETOTEXT(A2, 1)
=VALUETOTEXT(A3, 0)
=VALUETOTEXT(A3, 1)
=VALUETOTEXT(A4, 0)
=VALUETOTEXT(A4, 1)
=VALUETOTEXT(A5, 0)
=VALUETOTEXT(A5, 1)
=VALUETOTEXT(A6, 0)
=VALUETOTEXT(A6, 1)
=VALUETOTEXT(A7, 0)
=VALUETOTEXT(A7, 1)