ExcelFlux

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

RowA
6Input
77
8North
9-2
Record 1
=VALUETOTEXT(A7)

Expected result7

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference