Text Functions
| ARRAYTOTEXT | (2021) New. The contents of an array or cell range converted to text. |
| ASC | (Japanese) The text string converted from double byte to single byte characters. |
| BAHTTEXT | The number converted to a Thai text string and appends 'Baht'. |
| CHAR | The character with the corresponding ANSI/ASCII number. |
| CLEAN | The text string with all the non-printable characters removed. |
| CODE | The ANSI/ASCII number for the first character in a text string. |
| CONCAT | (2019) New. The text string that is a concatenation of cell ranges and strings. |
| CONCATENATE | (CONCAT) The text string that is a concatenation of several strings. |
| DBCS | (Japanese) The text string converted from single byte to double byte characters. |
| DOLLAR | The text string of a number with the dollar formatting $0,000.00. |
| EXACT | The value True or False based on whether two strings match exactly. |
| FIND | The starting position of a substring within a larger text string (case sensitive). |
| FIXED | The text string of a number rounded to a fixed number of decimal places. |
| JIS | (Japanese) The text string converted from single byte to double byte characters (renamed). |
| LEFT | The first or left most characters in a text string. |
| LEN | The number of characters in a text string. |
| LOWER | The text string with all the characters converted to lowercase. |
| MID | The characters from the middle of a text string. |
| NUMBERVALUE | The number that a text string represents (current locale). |
| PHONETIC | The phonetic characters from a text string. |
| PROPER | The text string with the first letter of every word as a capital letter. |
| REGEXEXTRACT | (2024) Preview. The characters that match a regular expression. |
| REGEXREPLACE | (2024) Preview. The text string after replacing characters that match a regular expression. |
| REGEXTEST | (2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |
| REPLACE | The text string after replacing characters in a specific location. |
| REPT | The text string repeated a number of times. |
| RIGHT | The last or right most characters in a text string. |
| SEARCH | The starting position of a substring within a larger text string (not case sensitive). |
| SUBSTITUTE | The text string after replacing instances of a substring. |
| T | The text string of the value given. |
| TEXT | The number as a formatted text string. |
| TEXTAFTER | (2022) New. The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (2022) New. The characters from the start of a text string before a delimiter. |
| TEXTJOIN | (2019) New. The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT | (2022) New. The text string split into multiple columns using delimiters. |
| TRANSLATE | (2024) Preview. The text string translated into another language. |
| TRIM | The text string with all extra spaces removed from the beginning, middle and end. |
| UNICHAR | The character with the corresponding UNICODE character. |
| UNICODE | The unicode number for the first character in a text string. |
| UPPER | The text string with all the characters converted to uppercase. |
| VALUE | (NUMBERVALUE) The number that a text string represents (renamed). |
| VALUETOTEXT | (2021) New. The value converted to text. |
| ARRAYTOTEXT (2021) New. The contents of an array or cell range converted to text. |
| ASC (Japanese) The text string converted from double byte to single byte characters. |
| BAHTTEXT The number converted to a Thai text string and appends 'Baht'. |
| CHAR The character with the corresponding ANSI/ASCII number. |
| CLEAN The text string with all the non-printable characters removed. |
| CODE The ANSI/ASCII number for the first character in a text string. |
| CONCAT (2019) New. The text string that is a concatenation of cell ranges and strings. |
| CONCATENATE (CONCAT) The text string that is a concatenation of several strings. |
| DBCS (Japanese) The text string converted from single byte to double byte characters. |
| DOLLAR The text string of a number with the dollar formatting $0,000.00. |
| EXACT The value True or False based on whether two strings match exactly. |
| FIND The starting position of a substring within a larger text string (case sensitive). |
| FIXED The text string of a number rounded to a fixed number of decimal places. |
| JIS (Japanese) The text string converted from single byte to double byte characters (renamed). |
| LEFT The first or left most characters in a text string. |
| LEN The number of characters in a text string. |
| LOWER The text string with all the characters converted to lowercase. |
| MID The characters from the middle of a text string. |
| NUMBERVALUE The number that a text string represents (current locale). |
| PHONETIC The phonetic characters from a text string. |
| PROPER The text string with the first letter of every word as a capital letter. |
| REGEXEXTRACT (2024) Preview. The characters that match a regular expression. |
| REGEXREPLACE (2024) Preview. The text string after replacing characters that match a regular expression. |
| REGEXTEST (2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |
| REPLACE The text string after replacing characters in a specific location. |
| REPT The text string repeated a number of times. |
| RIGHT The last or right most characters in a text string. |
| SEARCH The starting position of a substring within a larger text string (not case sensitive). |
| SUBSTITUTE The text string after replacing instances of a substring. |
| T The text string of the value given. |
| TEXT The number as a formatted text string. |
| TEXTAFTER (2022) New. The characters from the end of a text string after a delimiter. |
| TEXTBEFORE (2022) New. The characters from the start of a text string before a delimiter. |
| TEXTJOIN (2019) New. The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT (2022) New. The text string split into multiple columns using delimiters. |
| TRANSLATE (2024) Preview. The text string translated into another language. |
| TRIM The text string with all extra spaces removed from the beginning, middle and end. |
| UNICHAR The character with the corresponding UNICODE character. |
| UNICODE The unicode number for the first character in a text string. |
| UPPER The text string with all the characters converted to uppercase. |
| VALUE (NUMBERVALUE) The number that a text string represents (renamed). |
| VALUETOTEXT (2021) New. The value converted to text. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top