Skip to content
ExcelExcel 2021+

VALUETOTEXT function in Excel

Returns text from any specified value

=VALUETOTEXT(value, [format])

VALUETOTEXT syntax and parameters

Two arguments, one required.

  • valueanyRequired

    The value to return as text. Required.

  • formatnumberOptional

    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.

VALUETOTEXT examples

Formulas you'll actually reuse.

  1. Any value as plain text — a date shows its serial number, an error shows its code:

    =VALUETOTEXT(A2)

  2. Strict format wraps text in quotes, so blanks and stray spaces become visible:

    =VALUETOTEXT(A2, 1)

VALUETOTEXT in Google Sheets

No direct equivalent — here's the way around.

Try VALUETOTEXT in the playground

Edit the example — nothing to install.

Preloaded with the VALUETOTEXT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.