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 FunctionDescriptionSyntax with ArgumentsSyntax onlyArguments only
1ARRAYTOTEXTReturns 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)
2ASCChanges 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.
3BAHTTEXTConverts 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.
4CHARReturns 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.
5CLEANRemoves 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.
6CODEReturns 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.
7CONCATCombines 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.
8CONCATENATECombines 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.
9DBCSConverts 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.
10DOLLARConverts 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.
11EXACTCompares 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.
12FINDLocates 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.
13FINDBLocates 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.
14FIXEDRounds 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.
15JISConverts 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.
16LEFTReturns 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.
17LEFTBReturns 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.
18LENReturns 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.
19LENBReturns 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.
20LOWERConverts 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.
21MIDReturns 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.
22MIDBReturns 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.
23NUMBERVALUEConverts 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.
24PHONETICExtracts 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.
25PROPERCapitalizes 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.
26REPLACEReplaces 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.
27REPLACEBReplaces 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.
28REPTRepeats 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.
29RIGHTReturns 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.
30RIGHTBReturns 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.
31SEARCHLocate 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
32SEARCHBLocate 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
33SUBSTITUTESubstitutes 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.
34TReturns 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.
35TEXTChanges 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.
36TEXTJOINCombines 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
37TRIMRemoves 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.
38UNICHARReturns 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.
39UNICODEReturns 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.
40UPPERConverts text to uppercase=UPPER(texttext [required]: The text you want converted to uppercase.)=UPPER(text)
  • text (required): The text you want converted to uppercase.
41VALUEConverts 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.
42VALUETOTEXTReturns 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:

Created by admin on 2/9/2021

 

0 Comments for '(Excel) - List of Excel Text Functions with Syntax and Arguments'   

 
Email me replies   

Please kindly review and accept Terms of Use and Cookie & Policy Policy