Excel Spreadsheets Functions: Text
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
This
page is offered to you as reference See Excel Text formulas in chapter 22 |
Excel Lesson 24J of 24: Excel Spreadsheets Text Functions List (24)Here is the list of the functions of the text category. Of the 24 functions of the text category 10 are interesting and useful. Follow the links below to discover formulas using them. When working with text the most important tool is not a function but the ampersand & |
||
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 |
Excel Table of Contents |
Discover Even More in 50 Excel spreadsheets |
|
613-749-4695 |
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Spreadsheets Functions: Text