Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Returns the number (code point) corresponding to the first character of the text.
Accepts any array and returns the text representations of the array values.
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
Returns a specified number of characters from the beginning of a text in bytes
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
Converts a text string that represents a number to a number.
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.
LEN returns the number of characters in a text string.
Converts all uppercase letters in a text string to lowercase.
REGEXTEST Function
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
The SEARCH function locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. For example, to find the position of the letter "n" in the word "printer", you can use the following function: =SEARCH("n","printer") This function returns 4 because "n" is the fourth character in the word "printer." You can also search for words within other words. For example, the function =SEARCH("base","database") returns 5, because the word "base" begins at the fifth character of the word "database". You can use the SEARCH to determine the location of a character or text string within another text string, and then use the MID to return the text, or use the REPLACE to change the text. These functions are demonstrated in Example 1 in this article.
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
Replaces part of text by bytes (DBCS)
Returns a specified number of characters from the end of text based on bytes
Returns the text referred to by value.
With the DETECTLANGUAGE() function, you can easily identify the language used in a specified text or range. This function uses Microsoft Translation Services.
The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the $#,##0.00_);($#,##0.00) number format, although the currency symbol that is applied depends on your local language settings.
The function described in this Help topic converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon your language settings. For Japanese, this function changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
LEFT returns the first character or characters in a text string, based on the number of characters you specify.
Returns a portion of text starting at a specified position based on bytes
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
TEXTSPLIT function
Converts a number to Thai text and adds a suffix of "Baht." You can change the Baht format to a different style in the Excel desktop application by using Regional and Language Options (Windows Start menu, Control Panel).
For Double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters.
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
Returns the position of a text in another text in bytes (DBCS, for double-byte languages) — like FIND but byte-based
Converts text to uppercase.
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
Finds the position of a text inside another text (case-sensitive)
This article shows you how REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression.
REGEXREPLACE Function
Value returned if no match is found. By default, #N/A is returned.
Returns the Unicode character that is referenced by the given numeric value.
value returned by a previously executed REGISTER or REGISTER.ID function.
Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Extracts the phonetic (furigana) characters from a text string.
Value returned if no match is found. By default, #N/A is returned.
Returns the length of a text in bytes — each double-byte character counts as 2
The TRANSLATE() function allows you to translate text from one language to another in Microsoft Excel by using Microsoft Translation Services.
Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
VALUETOTEXT function
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.