List of Excel Text Functions with Syntax and Arguments

This reference table lists all officially documented Text Functions. It is based on the Excel Help documentation and linked in each row when clicking on the function name. Export the table and/or display additional columns via the symbols to the top right of the table. Please report errors or inconsistencies via the comment function at the bottom of this page. Also check the main table with List of all Excel Functions.

#	Excel Function	Description	Syntax with Arguments	Syntax only	Arguments only
1	ARRAYTOTEXT	Returns an array of text values from any specified range	=ARRAYTOTEXT(arrayarray [required]: The array to return as text., [formatformat [optional]: The format of the returned data as 0 (default) or 1 (strict format including escape characters)])	=ARRAYTOTEXT(array, [format])	array (required): The array to return as text. format (optional): The format of the returned data as 0 (default) or 1 (strict format including escape characters)
2	ASC	Changes full-width (double-byte) characters to half-width (single-byte) characters For double-byte character set	=ASC(texttext [required]: The text or a reference to a cell that contains the text you want to change.)	=ASC(text)	text (required): The text or a reference to a cell that contains the text you want to change.
3	BAHTTEXT	Converts a number to Thai text and adds a suffix of "Baht	=BAHTTEXT(numbernumber [required]: A number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number.)	=BAHTTEXT(number)	number (required): A number you want to convert to text, or a reference to a cell containing a number, or a formula that evaluates to a number.
4	CHAR	Returns the character specified by a number	=CHAR(numbernumber [required]: A number between 1 and 255 specifying which character you want.)	=CHAR(number)	number (required): A number between 1 and 255 specifying which character you want.
5	CLEAN	Removes all nonprintable characters from text	=CLEAN(texttext [required]: Any worksheet information from which you want to remove nonprintable characters.)	=CLEAN(text)	text (required): Any worksheet information from which you want to remove nonprintable characters.
6	CODE	Returns a numeric code for the first character in a text string	=CODE(texttext [required]: The text for which you want the code of the first character.)	=CODE(text)	text (required): The text for which you want the code of the first character.
7	CONCAT	Combines the text from multiple ranges and/or strings	=CONCAT(text1text1 [required]: Text item to be joined., [text2text2 [optional]: Additional text items to be joined.], ..)	=CONCAT(text1, [text2], ..)	text1 (required): Text item to be joined. text2 (optional): Additional text items to be joined.
8	CONCATENATE	Combines the text from multiple ranges and/or strings (deprecated; use CONCAT instead)	=CONCATENATE(text1text1 [required]: Text item to be joined., [text2text2 [optional]: Additional text items to be joined.], ..)	=CONCATENATE(text1, [text2], ..)	text1 (required): Text item to be joined. text2 (optional): Additional text items to be joined.
9	DBCS	Converts half-width (single-byte) letters within a character string to full-width (double-byte) characters	=DBCS(texttext [required]: The text or a reference to a cell that contains the text you want to change.)	=DBCS(text)	text (required): The text or a reference to a cell that contains the text you want to change.
10	DOLLAR	Converts a number to text using currency format, with the decimals rounded to the number of places specified	=DOLLAR(numbernumber [required]: A number, a reference to a cell containing a number, or a formula that evaluates to a number., [decimalsdecimals [optional]: The number of digits to the right of the decimal point.])	=DOLLAR(number, [decimals])	number (required): A number, a reference to a cell containing a number, or a formula that evaluates to a number. decimals (optional): The number of digits to the right of the decimal point.
11	EXACT	Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise	=EXACT(text1text1 [required]: The first text string., text2text2 [required]: The second text string.)	=EXACT(text1, text2)	text1 (required): The first text string. text2 (required): The second text string.
12	FIND	Locates 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. Counts each single- or double-byte character as 1	=FIND(find_textfind_text [required]: Text to find (needle)., within_textwithin_text [required]: Text to find in (haystack)., [start_numstart_num [optional]: Character at which to start search.])	=FIND(find_text, within_text, [start_num])	find_text (required): Text to find (needle). within_text (required): Text to find in (haystack). start_num (optional): Character at which to start search.
13	FINDB	Locates 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. Counts double-byte charaters as 2 if supported by language setting	=FIND(find_textfind_text [required]: Text to find (needle)., within_textwithin_text [required]: Text to find in (haystack)., [start_numstart_num [optional]: Character at which to start search.])	=FIND(find_text, within_text, [start_num])	find_text (required): Text to find (needle). within_text (required): Text to find in (haystack). start_num (optional): Character at which to start search.
14	FIXED	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	=FIXED(numbernumber [required]: The number you want to round and convert to text., [decimalsdecimals [optional]: The number of digits to the right of the decimal point.], [no_commasno_commas [optional]: A logical value that, if TRUE, prevents FIXED from including commas in the returned text.])	=FIXED(number, [decimals], [no_commas])	number (required): The number you want to round and convert to text. decimals (optional): The number of digits to the right of the decimal point. no_commas (optional): A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
15	JIS	Converts half-width (single-byte) letters within a character string to full-width (double-byte) characters	=JIS(texttext [required]: The text or a reference to a cell that contains the text you want to change.)	=JIS(text)	text (required): The text or a reference to a cell that contains the text you want to change.
16	LEFT	Returns the first character or characters in a text string, based on the number of characters you specify. Counts each single- or double-byte character as 1	=LEFT(texttext [required]: The text string that contains the characters you want to extract., [num_charsnum_chars [optional]: Specifies the number of characters you want LEFT to extract.])	=LEFT(text, [num_chars])	text (required): The text string that contains the characters you want to extract. num_chars (optional): Specifies the number of characters you want LEFT to extract.
17	LEFTB	Returns the first character or characters in a text string, based on the number of characters you specify. Counts double-byte charaters as 2 if supported by language setting	=LEFTB(texttext [required]: The text string that contains the characters you want to extract., [num_bytesnum_bytes [optional]: Specifies the number of characters in bytes you want LEFTB to extract.])	=LEFTB(text, [num_bytes])	text (required): The text string that contains the characters you want to extract. num_bytes (optional): Specifies the number of characters in bytes you want LEFTB to extract.
18	LEN	Returns the number of characters in a text string. Counts each single- or double-byte character as 1	=LEN(texttext [required]: The text whose length you want to find. Spaces count as characters.)	=LEN(text)	text (required): The text whose length you want to find. Spaces count as characters.
19	LENB	Returns the number of characters in a text string. Counts double-byte charaters as 2 if supported by language setting	=LENB(texttext [required]: The text whose length you want to find. Spaces count as characters.)	=LENB(text)	text (required): The text whose length you want to find. Spaces count as characters.
20	LOWER	Converts all uppercase letters in a text string to lowercase	=LOWER(texttext [required]: The text you want to convert to lowercase.)	=LOWER(text)	text (required): The text you want to convert to lowercase.
21	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. Counts each single- or double-byte character as 1	=MID(text, start_numstart_num [required]: The position of the first character you want to extract in text., num_charsnum_chars [required]: Specifies the number of characters you want MID to return from text.)	=MID(text, start_num, num_chars)	start_num (required): The position of the first character you want to extract in text. num_chars (required): Specifies the number of characters you want MID to return from text.
22	MIDB	Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. Counts double-byte charaters as 2 if supported by language setting	=MIDB(texttext [required]: The text string containing the characters you want to extract., start_numstart_num [required]: The position of the first character you want to extract in text., num_bytesnum_bytes [required]: Specifies the number of characters in bytes you want MIDB to return from text.)	=MIDB(text, start_num, num_bytes)	start_num (required): The position of the first character you want to extract in text. num_bytes (required): Specifies the number of characters in bytes you want MIDB to return from text. text (required): The text string containing the characters you want to extract.
23	NUMBERVALUE	Converts text to a number, in a locale-independent way	=NUMBERVALUE(texttext [required]: The text to convert to a number., [decimal_separatordecimal_separator [optional]: The character used to separate the integer and fractional part of the result.], [group_separatorgroup_separator [optional]: The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. ])	=NUMBERVALUE(text, [decimal_separator], [group_separator ])	text (required): The text to convert to a number. decimal_separator (optional): The character used to separate the integer and fractional part of the result. group_separator (optional): The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands.
24	PHONETIC	Extracts the phonetic (furigana) characters from a text string	=PHONETIC(referencereference [required]: Text string or a reference to a single cell or a range of cells that contain a furigana text string.)	=PHONETIC(reference)	reference (required): Text string or a reference to a single cell or a range of cells that contain a furigana text string.
25	PROPER	Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter	=PROPER(texttext [required]: Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.)	=PROPER(text)	text (required): Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
26	REPLACE	Replaces part of a text string, based on the number of characters you specify, with a different text string. Counts each single- or double-byte character as 1	=REPLACE(old_textold_text [required]: Text in which you want to replace some characters., start_numstart_num [required]: The position of the character in old_text that you want to replace with new_text., num_charsnum_chars [required]: The number of characters in old_text that you want REPLACE to replace with new_text., new_textnew_text [required]: The text that will replace characters in old_text.)	=REPLACE(old_text, start_num, num_chars, new_text)	start_num (required): The position of the character in old_text that you want to replace with new_text. num_chars (required): The number of characters in old_text that you want REPLACE to replace with new_text. new_text (required): The text that will replace characters in old_text. old_text (required): Text in which you want to replace some characters.
27	REPLACEB	Replaces part of a text string, based on the number of characters you specify, with a different text string. Counts double-byte charaters as 2 if supported by language setting	=REPLACEB(old_textold_text [required]: Text in which you want to replace some characters., start_numstart_num [required]: The position of the character in old_text that you want to replace with new_text., num_bytesnum_bytes [required]: The number of bytes in old_text that you want REPLACEB to replace with, new_textnew_text [required]: The text that will replace characters in old_text.)	=REPLACEB(old_text, start_num, num_bytes, new_text)	start_num (required): The position of the character in old_text that you want to replace with new_text. num_bytes (required): The number of bytes in old_text that you want REPLACEB to replace with new_text (required): The text that will replace characters in old_text. old_text (required): Text in which you want to replace some characters.
28	REPT	Repeats text a given number of times	=REPT(texttext [required]: The text you want to repeat., number_timesnumber_times [required]: A positive number specifying the number of times to repeat text.)	=REPT(text, number_times)	text (required): The text you want to repeat. number_times (required): A positive number specifying the number of times to repeat text.
29	RIGHT	Returns the last character or characters in a text string, based on the number of characters you specify. Counts each single- or double-byte character as 1	=RIGHT(texttext [required]: The text string containing the characters you want to extract., [num_charsnum_chars [optional]: Specifies the number of characters you want RIGHT to extract.])	=RIGHT(text, [num_chars])	text (required): The text string containing the characters you want to extract. num_chars (optional): Specifies the number of characters you want RIGHT to extract.
30	RIGHTB	Returns the last character or characters in a text string, based on the number of characters you specify. Counts double-byte charaters as 2 if supported by language setting	=RIGHTB(texttext [required]: The text string containing the characters you want to extract., [num_bytesnum_bytes [optional]: Specifies the number of characters you want RIGHTB to extract, based on bytes. ])	=RIGHTB(text, [num_bytes])	text (required): The text string containing the characters you want to extract. num_bytes (optional): Specifies the number of characters you want RIGHTB to extract, based on bytes.
31	SEARCH	Locate one text string within a second text string, and return starting position of second text string. Counts each single- or double-byte character as 1	=SEARCH(find_textfind_text [required]: The text that you want to find (needle), within_textwithin_text [required]: The text in which you want to search for (haystack), [start_numstart_num [optional]: Starting position of search ])	=SEARCH(find_text, within_text, [start_num])	find_text (required): The text that you want to find (needle) within_text (required): The text in which you want to search for (haystack) start_num (optional): Starting position of search
32	SEARCHB	Locate one text string within a second text string, and return starting position of second text string. Counts double-byte charaters as 2 if supported by language setting	=SEARCHB(find_textfind_text [required]: The text that you want to find (needle), within_textwithin_text [required]: The text in which you want to search for (haystack), [start_numstart_num [optional]: Starting position of search ])	=SEARCHB(find_text, within_text, [start_num])	find_text (required): The text that you want to find (needle) within_text (required): The text in which you want to search for (haystack) start_num (optional): Starting position of search
33	SUBSTITUTE	Substitutes new_text for old_text in a text string	=SUBSTITUTE(texttext [required]: The text or the reference to a cell containing text for which you want to substitute characters., old_textold_text [required]: The text you want to replace., new_textnew_text [required]: The text you want to replace old_text with., [instance_numinstance_num [optional]: Specifies which occurrence of old_text you want to replace with new_text.])	=SUBSTITUTE(text, old_text, new_text, [instance_num])	old_text (required): The text you want to replace. new_text (required): The text you want to replace old_text with. instance_num (optional): Specifies which occurrence of old_text you want to replace with new_text. text (required): The text or the reference to a cell containing text for which you want to substitute characters.
34	T	Returns the text referred to by value	=T(valuevalue [required]: The value you want to test.)	=T(value)	value (required): The value you want to test.
35	TEXT	Changes the way a number appears by applying formatting to it with format codes	=TEXT(valuevalue [required]: A numeric value that you want to be converted into text., format_textformat_text [required]: A text string that defines the formatting that you want to be applied to the supplied value.)	=TEXT(value, format_text)	value (required): A numeric value that you want to be converted into text. format_text (required): A text string that defines the formatting that you want to be applied to the supplied value.
36	TEXTJOIN	Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined	=TEXTJOIN(delimiterdelimiter [required]: A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string., ignore_emptyignore_empty [required]: If TRUE, ignores empty cells., text1text1 [required]: Text item to be joined., [text2text2 [optional]: Additional optional text items], ...)	=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)	delimiter (required): A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. ignore_empty (required): If TRUE, ignores empty cells. text1 (required): Text item to be joined. text2 (optional): Additional optional text items
37	TRIM	Removes all spaces from text except for single spaces between words	=TRIM(texttext [required]: The text from which you want spaces removed.)	=TRIM(text)	text (required): The text from which you want spaces removed.
38	UNICHAR	Returns the Unicode character that is referenced by the given numeric value	=UNICHAR(numbernumber [required]: Number is the Unicode number that represents the character.)	=UNICHAR(number)	number (required): Number is the Unicode number that represents the character.
39	UNICODE	Returns the number (code point) corresponding to the first character of the text	=UNICODE(texttext [required]: Text is the character for which you want the Unicode value.)	=UNICODE(text)	text (required): Text is the character for which you want the Unicode value.
40	UPPER	Converts text to uppercase	=UPPER(texttext [required]: The text you want converted to uppercase.)	=UPPER(text)	text (required): The text you want converted to uppercase.
41	VALUE	Converts a text string that represents a number to a number	=VALUE(texttext [required]: The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.)	=VALUE(text)	text (required): The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
42	VALUETOTEXT	Returns text from any specified value	=VALUETOTEXT(valuevalue [required]: The value to return as text., [formatformat [optional]: The format of the returned data, one of two values:])	=VALUETOTEXT(value, [format])	value (required): The value to return as text. format (optional): The format of the returned data, one of two values:

Microsoft Excel Shortcuts

Advertising for Consideration:

Ads for Consideration:

List of Excel Text Functions with Syntax and Arguments

Microsoft Excel Shortcuts

Related: