- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
-
Functions T to Z
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
- VALUE
- VALUETOTEXT
- VAR
- VAR.P
- VAR.S
- VARA
- VARISPARKLINE
- VARP
- VARPA
- VBARSPARKLINE
- VDB
- VLOOKUP
- VSTACK
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WINLOSSSPARKLINE
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- YEAR
- YEARFRAC
- YEARSPARKLINE
- YIELD
- YIELDDISC
- YIELDMAT
- Z.TEST
- ZTEST
VALUETOTEXT
This function returns text values from any specified range. It returns text values as it is and converts non-text values to text.
Syntax
VALUETOTEXT (value, format)
Argument
This function has the following arguments:
| Argument | Description |
|---|---|
| value | [Required] The value to return as text. |
| format | [Optional] The format of returned data. * 0 (default) - Concise format which returns text that is easy to read in a cell with general formatting applied. * 1 - Strict format which returns text that can be parsed in the formula bar and includes escape characters and row delimiters. The text returned is encapsulated in quotes except for booleans, numbers, and errors. |
Remarks
If the format option is set to anything other than 0 or 1, the function returns the #VALUE! error value.
Data Types
The concise format returns a text value, whereas the strict format returns an array of the same size and shape as the input.
Examples
VALUETOTEXT(B2:B8)
VALUETOTEXT(D1:D5, 1)
Version Available
This function is available in product version 14.1 or later.