Excel TEXT functions Syntax List

  • Click here to download the Excel TEXT Functions syntax list data in PDF version
  • Click here to download the Excel TEXT Functions syntax list data in an excel workbook.

Below the list of Excel TEXT functions along with Syntax

S.noFunction NameSyntax
1REPLACEREPLACE(old_text,
start_num,
num_chars,new_text)
2LENLEN(text)
3UPPERUPPER(text)
4LOWERLOWER(text)
5PROPERPROPER(text)
6RIGHTRIGHT(text,
[num_chars])
7LEFTLEFT(text,
[num_chars])
8MIDMID(text,
start_num,
num_chars)
9BAHTTEXTBAHTTEXT(number)
10CHARCHAR(number)
11CLEANCLEAN(text)
12CODECODE(text)
13CONCATCONCAT(text1,[text2],……)
14TEXTJOINTEXTJOIN(delimiter,
ignore_empty,
text1,[text2],…)
15DOLLARDOLLAR(number,[decimals])
16EXACTEXACT(text1,text2)
17FINDFIND(find_text,
within_text,
[start_num])
18SEARCHSEARCH(find_text,
within_text,[start_num])
19FIXEDFIXED(number,
[decimals],
[no_commas])
20NUMBERVALUENUMBERVALUE(text,
[decimal_separator],
[group_separator])
21REPTREPT(text,number_times)
22SUBSTITUTESUBSTITUTE(text,
old_text,
new_text,
[instance_num])
23T FUNCTIONT(value)
24TEXTTEXT(value,format_text)
25TRIMTRIM(text)
26VALUEVALUE(text)
27UNICODEUNICODE(text)
28UNICHARUNICHAR(number)