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.


VALUETOTEXT(value, [format])

The VALUETOTEXT function syntax has the following arguments.





The value to return as text.



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.

See Also


Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.