Excel TEXT functions Syntax List

Last modified date

Below the list of Excel TEXT functions along with Syntax

S.no Function Name Syntax
1 REPLACE REPLACE(old_text,
start_num,
num_chars,
new_text)
2 LEN LEN(text)
3 UPPER UPPER(text)
4 LOWER LOWER(text)
5 PROPER PROPER(text)
6 RIGHT RIGHT(text,
[num_chars])
7 LEFT LEFT(text,
[num_chars])
8 MID MID(text,s
tart_num,
num_chars)
9 BAHTTEXT BAHTTEXT(number)
10 CHAR CHAR(number)
11 CLEAN CLEAN(text)
12 CODE CODE(text)
13 CONCAT CONCAT(text1,[text2],……)
14 TEXTJOIN TEXTJOIN(delimiter,
ignore_empty,
text1,
[text2],…)
15 DOLLAR DOLLAR(number,
[decimals])
16 EXACT EXACT(text1,text2)
17 FIND FIND(find_text,
within_text,
[start_num])
18 SEARCH SEARCH(find_text,
within_text,
[start_num])
19 FIXED FIXED(number,
[decimals],
[no_commas])
20 NUMBERVALUE NUMBERVALUE(text,
[decimal_separator],
[group_separator])
21 REPT REPT(text,number_times)
22 SUBSTITUTE SUBSTITUTE(text,
old_text,
new_text,
[instance_num])
23 T FUNCTION T(value)
24 TEXT TEXT(value,format_text)
25 TRIM TRIM(text)
26 VALUE VALUE(text)
27 UNICODE UNICODE(text)
28 UNICHAR UNICHAR(number)
  • 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment