Basic Text Functions
Text Functions are used to manipulate, clean, format, and extract text data in Excel. These functions are commonly used when working with names, addresses, phone numbers, employee IDs, and other text-based information.
LEN Function
Returns the total number of characters in a text string, including spaces.
Syntax
=LEN(text)
Arguments
| Argument | Description |
|---|---|
| text | Text whose length is to be calculated. |
Example: =LEN(“Excel”)
Result: 5
UPPER Function
Converts all letters in a text string to uppercase.
Syntax
=UPPER(text)
Example: =UPPER(“excel training”)
Result: EXCEL TRAINING
LOWER Function
Converts all letters in a text string to lowercase.
Syntax
=LOWER(text)
Example: =LOWER(“EXCEL TRAINING”)
Result: excel training
PROPER Function
Converts the first letter of each word to uppercase and the remaining letters to lowercase.
Syntax
=PROPER(text)
Example: =PROPER(“rahul kumar”)
Result: Rahul Kumar
TRIM Function
Removes extra spaces from text while keeping single spaces between words.
Syntax
=TRIM(text)
Example: =TRIM(” Rahul Kumar “)
Result: Rahul Kumar
LEFT Function
Extracts characters from the left side of a text string.
Syntax
=LEFT(text,num_chars)
| Argument | Description |
|---|---|
| text | Source text. |
| num_chars | Number of characters to extract. |
Example: =LEFT(“Karnataka”,4)
Result: Karn
RIGHT Function
Extracts characters from the right side of a text string.
Syntax
=RIGHT(text,num_chars)
Example: =RIGHT(“Karnataka”,4)
Result: taka
MID Function
Extracts characters from the middle of a text string.
Syntax
=MID(text,start_num,num_chars)
| Argument | Description |
|---|---|
| text | Source text. |
| start_num | Starting position. |
| num_chars | Characters to return. |
Example: =MID(“Karnataka”,5,3)
Result: ata
CONCAT Function
Combines multiple text strings into one.
Syntax
=CONCAT(text1,text2,...)
Example: =CONCAT(“Rahul”,” “,”Kumar”)
Result: Rahul Kumar
FIND Function
Returns the position of a character or text within another text string. Case-sensitive.
Syntax
=FIND(find_text,within_text,[start_num])
Example: =FIND(“a”,”Karnataka”)
Result: 2
SEARCH Function
Similar to FIND but not case-sensitive.
Syntax
=SEARCH(find_text,within_text,[start_num])
Example: =SEARCH(“A”,”Karnataka”)
Result: 2
REPLACE Function
Replaces characters based on position.
Syntax
=REPLACE(old_text,start_num,num_chars,new_text)
Example: =REPLACE(“Excel”,1,2,”XX”)
Result: XXcel
SUBSTITUTE Function
Replaces specific text with new text.
Syntax
=SUBSTITUTE(text,old_text,new_text)
Example: =SUBSTITUTE(“Excel Training”,”Training”,”Course”)
Result: Excel Course
TEXT Function
Converts a number into formatted text.
Syntax
=TEXT(value,format_text)
Example: =TEXT(TODAY(),”dd-mmm-yyyy”)
Result: 04-Jun-2026
Summary
Text Functions help users clean, format, search, extract, combine, and manipulate text data efficiently. These functions are widely used in data cleaning, reporting, HR records, customer databases, and business analysis.
