Text Functions

ARRAYTOTEXT(Microsoft 365) The contents of an array or cell ranges converted into text.
ASCThe text string converted from double byte to single byte characters.
BAHTTEXTThe number converted to a Thai text string and appends 'Baht'.
CHARThe character with the corresponding ANSI/ASCII number.
CLEANThe text string with all the non-printable characters removed.
CODEThe 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.
DOLLARThe text string of a number with the dollar formatting $0,000.00.
EXACTThe value True or False based on whether two strings match exactly.
FINDThe starting position of a substring within a larger text string.
FIXEDThe 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).
LEFTThe first or left most characters in a text string.
LENThe number of characters in a text string.
LOWERThe text string with all the characters converted to lowercase.
MIDThe characters from the middle of a text string.
NUMBERVALUE(2013) The number that a text string represents (current locale).
PHONETICThe phonetic characters from a text string.
PROPERThe text string with the first letter of every word as a capital letter.
REPLACEThe text string after replacing characters in a specific location.
REPTThe text string repeated a number of times.
RIGHTThe last or right most characters in a text string.
SEARCHThe starting position of a substring within a larger text string.
SUBSTITUTEThe text string after replacing instances of a substring.
TThe text string of the value given.
TEXTThe 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 delimiter).
TEXTSPLIT(Microsoft 365) The text string split into multiple columns using delimiters.
TRIMThe 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.
UPPERThe 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 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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top