TEXT Function
Excel is mostly about the numerical data, but at times you can come across the data which has too much text and that is the time when Text Functions in Excel will help you to simplify the things easily.
| Functions |
Syntax |
Tutorial |
| TRIM Function |
TRIM(text) |
Exemple |
| CLEAN Function |
CLEAN(text) |
Exemple |
| CONCATENATE Function |
CONCATENATE(text1, [text2]…) |
Exemple |
| LEFT Function |
LEFT(text,num_chars) |
Exemple |
| MID Function |
MID(text,start_num, num_chars) |
Exemple |
| RIGHT Function |
RIGHT(text,num_chars) |
Exemple |
| LEN Function |
LEN(text) |
Exemple |
| LOWER Function |
LOWER(text) |
Exemple |
| PROPER Function |
PROPER(text) |
Exemple |
| UPPER Function |
UPPER(text) |
Exemple |
| FIND Function |
FIND(find_text, within_text, start_num) |
Exemple |
| SEARCH Function |
SEARCH(find_text,within_text,start_num) |
Exemple |
| TEXT Function |
TEXT(VALUE,format_text) |
Exemple |