Text Functions
- 3 minutes to read
This document describes text functions supported by a non-visual spreadsheet component.
Name | Description | Syntax |
---|---|---|
BAHTTEXT | Converts a number to text, using the ß (baht) currency format. | BAHTTEXT(number) |
CHAR | Returns the character specified by a number within the character set used by your system. | CHAR(number) A number must be between 1 and 255. |
CLEAN | Removes all non-printable characters from text. | CLEAN(text) The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. |
CODE | Returns the numeric code for the first character of a string. | CODE(text) |
CONCATENATE | Joins text strings. | CONCATENATE(text1, [text2], …) |
DOLLAR | Converts a number into text and applies a currency format. | DOLLAR(number, [decimals]) |
EXACT | Checks if two strings are exactly the same. | EXACT(text1, text2) |
FIND | Finds a substring or a character in a string. | FIND(find_text, within_text, [start_num]) |
FIXED | Rounds a number to certain number of decimal places and converts it to text. | FIXED(number, [decimals], [no_commas]) |
LEFT | Returns a specified number of characters from the start of a text string. | LEFT(text, [num_chars]) |
LEN | Returns the length of a text string. | LEN(text) |
LOWER | Converts all characters to lower case. | LOWER(text) |
MID | Returns a specified number of characters from the middle of a text string. | MID(text, start_num, num_chars) |
NUMBERVALUE | Converts text to a number, in a locale-independent way. | NUMBERVALUE(Text, [Decimal_separator], [Group_separator ]) |
PROPER | Converts all characters in a text string to proper case (first letter in a word is upper case and other letters are lower case) | PROPER(text) |
REPLACE | Replaces all or part of a text string with another string starting from a specified position. | REPLACE(old_text, start_num, num_chars, new_text) |
REPT | Returns a string that is composed of a specified text string, repeated a number of times. | REPT(text, number_times) |
RIGHT | Returns a specified number of characters from the end of a text string. | RIGHT(text,[num_chars]) |
SEARCH | Returns the position of a character or text string in a specified text string. | SEARCH(find_text,within_text,[start_num]) |
SUBSTITUTE | Substitutes all occurrences of a search text string within an original text string with the replacement text. | SUBSTITUTE(text, old_text, new_text, [instance_num]) |
T | Checks if the value is text. | T(value) |
TEXT | Converts a value to text. | TEXT(value, format_text) |
TRIM | Removes spaces at the start and end of a text string. | TRIM(text) |
UNICODE | Returns the number (code point) corresponding to the first character of the text. | UNICODE(text) |
UPPER | Converts all characters to upper case. | UPPER(text) |
VALUE | Converts a text string into a numeric value. | VALUE(text) |