Text & Data Functions

Remove Extra Characters. Convert Between Cases. Cutting Up & Piecing Together Text String. Information Functions. Convert Data Types.
  • CHAR

    Convert a number into a character according to the current Unicode table.

    table_number (number)
    The number of the character to look up from the current Unicode table in decimal format.
  • CLEAN

    Returns the text with the non-printable ASCII characters removed.

    CLEAN("AF"&CHAR(31))
    Try this example
    text (string)
    The text whose non-printable characters are to be removed.
  • CODE

    Returns the numeric Unicode map value of the first character in the string provided.

    string (string)
    The string whose first character's Unicode map value will be returned.
  • CONCAT

    Returns the concatenation of two values. Equivalent to the `&` operator.

    CONCAT("some","text")
    Try this example
    value1 (any)
    The value to which value2 will be appended.
    value2 (any)
    The value to append to value1.
  • CONCATENATE

    Appends strings to one another.

    CONCATENATE("Welcome", " ", "to", " ", "Antify!")
    Try this example
    string1 (string)
    The initial string.
    string2 (string)
    Optional: Additional strings to append in sequence.
  • DOLLAR

    Formats a number into the locale-specific currency format.

    DOLLAR(1.2351,4)
    Try this example
    number (number)
    The value to be formatted.
    number_of_places (number)
    Optional: 2 by default. The number of decimal places to display.
  • EXACT

    Tests whether two strings are identical.

    EXACT("Text", "text")
    Try this example
    string1 (string)
    The first string to compare
    string2 (string)
    The second string to compare
  • FIND

    Returns the position at which a string is first found within text, case-sensitive.

    FIND("wood","How much wood can a woodchuck chuck",14)
    Try this example
    search_for (string)
    The string to look for within text_to_search.
    text_to_search (string)
    The text to search for the first occurrence of search_for.
  • FINDB

    Returns the position at which a string is first found within text counting each double-character as 2.

    FINDB("新", "农历新年", 2)
    Try this example
    search_for (string)
    The string to look for within text_to_search.
    text_to_search (string)
    The text to search for the first occurrence of search_for.
  • FIXED

    Formats a number with a fixed number of decimal places.

    FIXED(3.141592653,2)
    Try this example
    number (number)
    The number to format.
    number_of_places (number)
    Optional: The number of decimal places to display in the result.
  • LEFT

    Returns a substring from the beginning of a specified string.

    LEFT("lorem ipsum")
    Try this example
    string (string)
    The string from which the left portion will be returned.
    number_of_characters (number)
    Optional: 1 by default. The number of characters to return from the left side of string.
  • LEFTB

    The LEFTB function returns the left portion of a string up to a certain number of bytes.

    LEFTB("熊本", 2)
    Try this example
    string (string)
    The string from which the left portion will be returned.
    num_of_bytes (number)
    Optional: The number of bytes to return from the left side of `string`.
  • LEN

    Returns the length of a string.

    LEN("lorem ipsum")
    Try this example
    text (string)
    The string whose length will be returned.
  • LENB

    The LENB function returns the length of a string in bytes.

    LENB("熊本")
    Try this example
    string (number)
    The string to get the length in bytes
  • LOWER

    LOWER("LOREM IPSUM")

    LOWER("LOREM IPSUM")
    Try this example
    text (string)
    The string to convert to lowercase.
  • MID

    Returns a segment of a string.

    MID("get this",5,4)
    Try this example
    string (string)
    The string to extract a segment from.
    starting_at (number)
    The index from the left of string from which to begin extracting. The first character in string has the index 1.
  • MIDB

    The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.

    MIDB("熊本=熊本",2,4)
    Try this example
    string (string)
    The string from which to extract a section.
    starting_at (number)
    The position in the input `string` to start extracting from.
  • NUMBERVALUE

    Converts a number in text format to numeric value, using specified decimal and group separators. This function can be used to convert locale-specific values into locale-independent values.

    NUMBERVALUE("6.000",",",".")
    Try this example
    text (string)
    The text to convert to a number.
    decimal_separator (string)
    Optional: The character for decimal values.
  • PROPER

    Capitalizes each word in a specified string.

    PROPER("some text")
    Try this example
    text_to_capitalize (string)
    The text which will be returned with the first letter of each word in uppercase and all other letters in lowercase.
  • REPLACE

    Replaces part of a text string with a different text string.

    REPLACE("Text", 1, 2, "11")
    Try this example
    text (string)
    The text, a part of which will be replaced.
    position (number)
    The position where the replacement will begin (starting from 1).
  • REPLACEB

    The REPLACEB function replaces part of a text string, based on a number of bytes, with a different text string.

    REPLACEB("熊本=熊本", 2, 3,"new")
    Try this example
    text (string)
    The text, a part of which will be replaced.
    position (number)
    The position where the replacement will begin (starting from 1).
  • REPT

    Returns specified text repeated a number of times.

    REPT("ha",4)
    Try this example
    text_to_repeat (string)
    The character or string to repeat.
    number_of_repetitions (number)
    The number of times text_to_repeat should appear in the value returned.
  • RIGHT

    Returns a substring from the end of a specified string.

    RIGHT("lorem ipsum")
    Try this example
    string (string)
    The string from which the right portion will be returned.
    number_of_characters (number)
    Optional: 1 by default. The number of characters to return from the right side of string.
  • RIGHTB

    The RIGHTB function returns the right portion of a string up to a certain number of bytes.

    RIGHTB("熊本", 2)
    Try this example
    string (string)
    The string from which the right portion will be returned.
    num_of_bytes (number)
    Optional: The number of bytes to return from the right side of `string`.
  • SEARCH

    Returns the position at which a string is first found within text, ignoring case.

    SEARCH("b","a b c d e f",2)
    Try this example
    search_for (string)
    The string to look for within text_to_search.
    text_to_search (string)
    The text to search for the first occurrence of search_for.
  • SEARCHB

    Returns the position at which a string is first found within text counting each double-character as 2.

    SEARCHB("新", "农历新年", 2)
    Try this example
    search_for (string)
    The string to look for within text_to_search.
    text_to_search (string)
    The text to search for the first occurrence of search_for.
  • SUBSTITUTE

    Replaces existing text with new text in a string.

    SUBSTITUTE("January 2, 2012",2,3,1)
    Try this example
    text_to_search (string)
    The text within which to search and replace.
    search_for (string)
    The string to search for within text_to_search.
  • T

    Returns string arguments as text.

    value (any)
    The argument to be converted to text.
  • TEXT

    Converts a number into text according to a specified format.

    TEXT(1.23,"$0.00")
    Try this example
    number (any)
    The number, date, or time to format.
    format (any)
    The pattern by which to format the number, enclosed in quotation marks.
  • TEXTJOIN

    Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.

    TEXTJOIN(" ", TRUE, "hello", "world")
    Try this example
    delimiter (string)
    A string, possibly empty, or a reference to a valid string. If empty, text will be simply concatenated.
    ignore_empty (boolean)
    A boolean; if TRUE, empty variables selected in the text arguments won't be included in the result.
  • TRIM

    Removes leading, trailing, and repeated spaces in text.

    TRIM(" lorem ipsum")
    Try this example
    text (string)
    The string or reference to a variable containing a string to be trimmed.
  • UNICHAR

    Returns the Unicode character for a number. This method supports returning characters in both the UTF-8 and UTF-16 character set.

    UNICHAR(68)
    Try this example
    number (number)
    The number to convert into a Unicode character. The number should be greater than 0.
  • UNICODE

    The UNICODE function returns the decimal Unicode value of the first character of the text.

    UNICODE("A")
    Try this example
    text (string)
    The string containing the character to be evaluated.
  • UPPER

    Converts a specified string to uppercase.

    UPPER("lorem ipsum")
    Try this example
    text (string)
    The string to convert to uppercase.
  • VALUE

    Converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value

    VALUE("123")
    Try this example
    text (string)
    The string containing the value to be converted.