Appendix J: Excel Spreadsheets Text Functions List (24)
This web page is an appendix. For more see Excel Text formulas in lesson 3-16
| Importance | Functions | What it Does |
| Interesting | CONCATENATE | Joins several text items into one text item |
| Interesting | FIND | Finds one text value within another (case-sensitive) |
| Interesting | LEFT | Returns the leftmost characters from a text value |
| Interesting | LEN | Returns the number of characters in a text string |
| Interesting | MID | Returns a specific number of characters from a text string starting at the position you specify |
| Interesting | REPT | Repeats text a given number of times |
| Interesting | RIGHT | Returns the rightmost characters from a text value |
| Interesting | TEXT | Formats a number and converts it to text |
| Interesting | TRIM | Removes spaces from text |
| Interesting | VALUE | Converts a text argument to a number |
|
Rarely Used |
BAHTTEXT | Converts a number to text, using the ß (baht) currency format |
|
Rarely Used |
CHAR | Returns the character specified by the code number |
|
Rarely Used |
CLEAN | Removes all nonprintable characters from text |
|
Rarely Used |
CODE | Returns a numeric code for the first character in a text string |
|
Rarely Used |
DOLLAR | Converts a number to text, using the $ (dollar) currency format |
|
Rarely Used |
EXACT | Checks to see if two text values are identical |
|
Rarely Used |
FIXED | Formats a number as text with a fixed number of decimals |
|
Rarely Used |
LOWER | Converts text to lowercase |
|
Rarely Used |
PROPER | Capitalizes the first letter in each word of a text value |
|
Rarely Used |
REPLACE | Replaces characters within text |
|
Rarely Used |
SEARCH | Finds one text value within another (not case-sensitive) |
|
Rarely Used |
SUBSTITUTE | Substitutes new text for old text in a text string |
|
Rarely Used |
T | Converts its arguments to text |
|
Rarely Used |
UPPER | Converts text to uppercase |