Author: Oscar Cronquist Article last updated on October 25, 2022

How to use the VALUETOTEXT function

The VALUETOTEXT function returns a value in text form. Text values are unmodified and non-text values are converted to text.

1. VALUETOTEXT Function Syntax

VALUETOTEXT(array, [format])

Back to top

2. VALUETOTEXT Function Arguments

array A cell reference or an array.
[format] Optional. This argument lets you change the output format.

0  - Default. Concise format, the returned value has general formatting applied.

1 - Strict format, includes escape characters. Encloses all values with quotes except for errors, numbers, and boolean values.

Back to top

3. VALUETOTEXT Function examples

How to use the VALUETOTEXT function

This example shows the VALUETOTEXT function with a 0 (zero) as the second argument meaning concise format.

Formula in cell C3:

=VALUETOTEXT(B3,0)

How to use the VALUETOTEXT function1

This example demonstrates how the VALUETOTEXT function returns values in strict form.

Formula in cell C3:

=VALUETOTEXT(B3, 1)

Text values have leading and trailing double quotes, remaining values are unchanged.

Back to top