VALUETOTEXT function

The VALUETOTEXT function returns text from any specified value. It passes text values unchanged, and converts non-text values to text.

Note: This is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Microsoft 365 subscribers.

Syntax

VALUETOTEXT(value, [format])

The VALUETOTEXT function syntax has the following arguments.

Argument	Description
value Required	The value to return as text.
format Optional	The format of the returned data, 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.

Argument

Description

value

Required

The value to return as text.

format

Optional

The format of the returned data, 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.

VALUETOTEXT function

Syntax

See Also

Need more help?

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.