The VALUETOTEXT function returns text from any specified value. It passes text values unchanged, and converts non-text values to text.
Syntax
VALUETOTEXT(value, [format])
The VALUETOTEXT function syntax has the following arguments.
| Argument | Description |
|---|---|
| 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.
Examples
Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
Note To convert "Seattle" to a linked data type, Select cell A6, and then select Data > Geography.
| Data | |||
|---|---|---|---|
| TRUE | |||
| 1234.01234 | |||
| Hello | |||
| #VALUE! | |||
| Seattle | |||
| 1234 | |||
| Concise Formula | Concise Result | Strict Formula | Strict Result |
| =VALUETOTEXT(A2, 0) | TRUE | =VALUETOTEXT(A2, 1) | TRUE |
| =VALUETOTEXT(A3, 0) | 1234.01234 | =VALUETOTEXT(A3, 1) | 1234.01234 |
| =VALUETOTEXT(A4, 0) | Hello | =VALUETOTEXT(A4, 1) | "Hello" |
| =VALUETOTEXT(A5, 0) | #VALUE! | =VALUETOTEXT(A5, 1) | #VALUE! |
| =VALUETOTEXT(A6, 0) | Seattle | =VALUETOTEXT(A6, 1) | "Seattle" |
| =VALUETOTEXT(A7, 0) | 1234 | =VALUETOTEXT(A7, 1) | 1234 |