- 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.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, start_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) |