- 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) |