Text Functions
ARRAYTOTEXT | (Microsoft 365) The contents of an array or cell ranges converted into text. |
ASC | 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) 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 | (2013) 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. |
FIXED | The text string of a number rounded to a fixed number of decimal places. |
JIS | (DBCS) 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 | (2013) 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. |
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. |
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 | (Microsoft 365) The characters from the end of a text string after a delimiter. |
TEXTBEFORE | (Microsoft 365) The characters from the start of a text string before a delimiter. |
TEXTJOIN | (2019) The text string that is a concatenation of several strings with a delimiter. |
TEXTSPLIT | (Microsoft 365) The text string split into multiple columns using delimiters. |
TRIM | The text string with all extra spaces removed from the beginning, middle and end. |
UNICHAR | (2013) The character with the corresponding UNICODE character. |
UNICODE | (2013) 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 | (Microsoft 365) The value converted to text. |
ARRAYTOTEXT (Microsoft 365) The contents of an array or cell ranges converted into text. |
ASC 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) 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 (2013) 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. |
FIXED The text string of a number rounded to a fixed number of decimal places. |
JIS (DBCS) 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 (2013) 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. |
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. |
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 (Microsoft 365) The characters from the end of a text string after a delimiter. |
TEXTBEFORE (Microsoft 365) The characters from the start of a text string before a delimiter. |
TEXTJOIN (2019) The text string that is a concatenation of several strings with a delimiter. |
TEXTSPLIT (Microsoft 365) The text string split into multiple columns using delimiters. |
TRIM The text string with all extra spaces removed from the beginning, middle and end. |
UNICHAR (2013) The character with the corresponding UNICODE character. |
UNICODE (2013) 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 (Microsoft 365) The value converted to text. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top