Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description of what each function does:
| Function |
Description |
|---|
| LEFT |
Extracts one or more characters from the left side of a text
string |
| RIGHT |
Extracts one or more characters from the right side of a text
string |
| MID |
Extracts characters from the middle of a text string; you
specify which character position to start from and how many
characters to include |
| CONCATENATE |
Assembles two or more text strings into one |
| REPLACE |
Replaces part of a text string with other text |
| LOWER |
Converts a text string to all lowercase |
| UPPER |
Converts a text string to all uppercase |
| PROPER |
Converts a text string to proper case |
| LEN |
Returns a text string’s length (number of
characters) |
