VALUETOTEXT function
text from any specified value.
Text · Excel 2021+
Where can you use it?
Data preparation and reporting teams. Use this group to clean, split or reformat IDs, names and descriptions before using them in reports.
Scenario in the workbook
Convert numbers and existing labels to one text data type for export.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | 7 |
| 8 | North |
| 9 | -2 |
Record 1
=VALUETOTEXT(A7)Expected result7
See the inputs and instructions for all 3 examplesSyntax
VALUETOTEXT(value, [format])
Copyable formulas
English Excel · en-US
=VALUETOTEXT(A7)Turkish Excel · tr-TR
=DEĞERMETİN(A7)Worked examples
Convert numbers and existing labels to one text data type for export.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Input |
| 7 | 7 |
| 8 | North |
| 9 | -2 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =VALUETOTEXT(A7) |
7 |
| Record 2 | =VALUETOTEXT(A8) |
North |
| Record 3 | =VALUETOTEXT(A9) |
-2 |