SpreadJS 14
Formula Reference / Formula Functions / Text Functions
In This Topic
    Text Functions
    In This Topic

    Spread provides the following lookup and reference functions, listed alphabetically.

    Function Description
    BAHTTEXT This function converts a number to Thai text and adds a suffix of "Baht"
    CHAR This function returns the character specified by a number.
    CLEAN This function removes all non-printable characters from text.
    CODE This function returns a numeric code to represent the first character in a text string. The returned code corresponds to the Windows character set (ANSI).
    CONCAT This function combines multiple text strings or numbers into one text string, the function will stay available for compatibility with "CONCATENATE" function.
    CONCATENATE This function combines multiple text strings or numbers into one text string.
    DOLLAR This function converts a number to text using currency format, with the decimals rounded to the specified place.
    FIND This function finds one text value within another and returns the text value’s position in the text you searched.
    FINDB This function finds one text value within another and returns the text value's position in the text you searched, and counts each double-byte characte as 2 when set DBCS as the default language.
    FIXED This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text.
    LEFT This function returns the specified leftmost characters from a text value, and based on the number of characters you specify.
    LEFTB This function returns the specified leftmost characters from a text value, and based on the number of bytes you specify.
    LEN This function returns the length of the number of characters in a text string.
    LENB This function returns the length of the number of bytes in a text string.
    LOWER This function converts text to lower case letters.
    MID This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of characters you specify.
    MIDB This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of bytes you specify.
    PROPER This function capitalizes the first letter in each word of a text string.
    REPLACE This function replaces part of a text string with a different text string, based on the number of characters you specify.
    REPLACEB This function replaces part of a text string with a different text string, based on the number of bytes you specify.
    REPT This function repeats text a specified number of times.
    RIGHT This function returns the specified rightmost characters from a text value, and based on the number of characters you specify.
    RIGHTB This function returns the specified rightmost characters from a text value, and based on the number of bytes you specify.
    SEARCH This function finds one text string in another text string and returns the index of the starting position of the found text.
    SEARCHB This function finds one text string in another text string and returns the index of the starting position of the found text, and counts each double-byte characte as 2 when set DBCS as the default language.
    SUBSTITUTE This function substitutes a new string for specified characters in an existing string.
    T This function returns the text in a specified cell.
    TEXT This function formats a number and converts it to text.
    TEXTJOIN This function combines multiple ranges and/or strings into one text, and the text includes a delimiter you specify between each text value.
    TRIM This function removes extra spaces from a string and leaves single spaces between words.
    UNICHAR This function returns the Unicode character of a given numeric reference.
    UNICODE This function returns the number corresponding to the first character of the text.
    UPPER This function converts text to uppercase letters.
    VALUE This function converts a text string that is a number to a numeric value.