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