Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / VALUETOTEXT
In This Topic
    VALUETOTEXT
    In This Topic

    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.