To get detailed information about a function, click its name in the first column.
Function |
Description |
---|---|
Returns an array of text values from any specified range |
|
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
|
Converts a number to text, using the ß (baht) currency format |
|
Returns the character specified by the code number |
|
Removes all nonprintable characters from text |
|
Returns a numeric code for the first character in a text string |
|
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. |
|
Joins several text items into one text item |
|
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
|
Converts a number to text, using the $ (dollar) currency format |
|
Checks to see if two text values are identical |
|
Finds one text value within another (case-sensitive) |
|
Formats a number as text with a fixed number of decimals |
|
Returns the leftmost characters from a text value |
|
Returns the number of characters in a text string |
|
Converts text to lowercase |
|
Returns a specific number of characters from a text string starting at the position you specify |
|
Converts text to number in a locale-independent manner |
|
Extracts the phonetic (furigana) characters from a text string |
|
Capitalizes the first letter in each word of a text value |
|
Replaces characters within text |
|
Repeats text a given number of times |
|
Returns the rightmost characters from a text value |
|
Finds one text value within another (not case-sensitive) |
|
Substitutes new text for old text in a text string |
|
Converts its arguments to text |
|
Formats a number and converts it to text |
|
Returns text that occurs after given character or string |
|
Returns text that occurs before a given character or string |
|
Combines the text from multiple ranges and/or strings |
|
Splits text strings by using column and row delimiters |
|
Removes spaces from text |
|
Returns the Unicode character that is references by the given numeric value |
|
Returns the number (code point) that corresponds to the first character of the text |
|
Converts text to uppercase |
|
Converts a text argument to a number |
|
Returns text from any specified value |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.