Table of Contents
To convert a value to text in Excel, you can use the TEXT function. This function allows you to specify the format in which you want the value to be displayed as text. Simply select the cell containing the value, enter the TEXT function in the formula bar, and specify the desired format in quotation marks. This will convert the value to text and display it in the specified format.
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 |
See Also
Cite this article
stats writer (2024). How do I convert a value to text in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-convert-a-value-to-text-in-excel/
stats writer. "How do I convert a value to text in Excel?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-do-i-convert-a-value-to-text-in-excel/.
stats writer. "How do I convert a value to text in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-convert-a-value-to-text-in-excel/.
stats writer (2024) 'How do I convert a value to text in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-convert-a-value-to-text-in-excel/.
[1] stats writer, "How do I convert a value to text in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How do I convert a value to text in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.