A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

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