Explanation
Text functions help you manipulate text stored in Excel cells.
Important Text Functions
|
Function |
Purpose |
|
LEFT |
Extracts characters from the left |
|
RIGHT |
Extracts characters from the right |
|
MID |
Extracts characters from the middle |
|
LEN |
Counts characters |
|
TRIM |
Removes extra spaces |
|
UPPER |
Converts text to uppercase |
|
LOWER |
Converts text to lowercase |
|
PROPER |
Capitalizes words |
|
CONCAT |
Combines text |
|
TEXTJOIN |
Combines text with a delimiter |
|
FIND |
Finds text position, case-sensitive |
|
SEARCH |
Finds text position, not case-sensitive |
|
SUBSTITUTE |
Replaces specific text |
|
REPLACE |
Replaces characters by position |
|
TEXT |
Formats numbers/dates as text |
Practice
Create a Customer Data sheet containing:
|
Customer Name |
City |
|
Customer ID |
|
amit kumar |
sirsa |
CUST-001 |
|
|
neha sharma |
hisar |
CUST-002 |
Use different text functions to clean and analyze the data.