Status | Column 1 | Title | Text |
|---|---|---|---|
Not started | Function | Description | |
Not started | ASC | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | |
Not started | ARRAYTOTEXT (2021) | Returns an array of text values from any specified range | |
Not started | BAHTTEXT | Converts a number to text, using the ß (baht) currency format | |
Not started | CHAR | Returns the character specified by the code number | |
Not started | CLEAN | Removes all nonprintable characters from text | |
Not started | CODE | Returns a numeric code for the first character in a text string | |
Not started | CONCAT (2019) | Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. | |
Not started | CONCATENATE | Joins several text items into one text item | |
Not started | DBCS (2013) | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters | |
Not started | DETECTLANGUAGE (Microsoft 365) | Identifies the language of a specified text | |
Not started | DOLLAR | Converts a number to text, using the $ (dollar) currency format | |
Not started | EXACT | Checks to see if two text values are identical | |
Done | FIND, FINDB | Finds one text value within another (case-sensitive) |
|
Not started | FIXED | Formats a number as text with a fixed number of decimals | |
Done | LEFT, LEFTB | Returns the leftmost characters from a text value |
|
Not started | LEN, LENB | Returns the number of characters in a text string |
|
Not started | LOWER | Converts text to lowercase |
|
Not started | MID, MIDB | Returns a specific number of characters from a text string starting at the position you specify |
|
Not started | NUMBERVALUE (2013) | Converts text to number in a locale-independent manner | |
Not started | PHONETIC | Extracts the phonetic (furigana) characters from a text string | |
Not started | PROPER | Capitalizes the first letter in each word of a text value |
|
Not started | REGEXEXTRACT (Microsoft 365) | Extracts strings within the provided text that matches the pattern | |
Not started | REGEXREPLACE (Microsoft 365) | Replaces strings within the provided text that matches the pattern with replacement | |
Not started | REGEXTEST (Microsoft 365) | Determines whether any part of text matches the pattern | |
Not started | REPLACE, REPLACEB | Replace Function : Replaces characters within text |
|
Not started | REPT | Repeats text a given number of times |
|
Not started | RIGHT, RIGHTB | Returns the rightmost characters from a text value |
|
Not started | SEARCH, SEARCHB | Finds one text value within another (not case-sensitive) | |
Not started | SUBSTITUTE | Substitutes new text for old text in a text string | |
Not started | T | Converts its arguments to text | |
Not started | TEXT | Formats a number and converts it to text |
|
Not started | TEXTAFTER (2024) | Returns text that occurs after given character or string | |
Not started | TEXTBEFORE (2024) | Returns text that occurs before a given character or string | |
Not started | TEXTJOIN (2019) | Text: Combines the text from multiple ranges and/or strings | |
Not started | TEXTSPLIT (2024) | Splits text strings by using column and row delimiters | |
Not started | TRANSLATE (Microsoft 365) | Translates a text from one language to another | |
Not started | TRIM | Removes spaces from text |
|
Not started | UNICHAR (2013) | Returns the Unicode character that is references by the given numeric value | |
Not started | UNICODE (2013) | Returns the number (code point) that corresponds to the first character of the text | |
Not started | UPPER | Converts text to uppercase |
|
Not started | VALUE | Converts a text argument to a number |
|
Not started | VALUETOTEXT (2021) | Returns text from any specified value |