Text Functions
CHAR(number) | Returns the character specified by the code number. |
CLEAN(text) | Removes all nonprintable characters from text. |
CODE(text) | Returns a numeric code for the first character in a text string. |
CONCATENATE(text1,text2,…) | Joins several text items into one text item. |
DOLLAR(number,decimals) | Converts a number to text, using currency format. |
EXACT(text1,text2) | Checks to see if two text values are identical. |
FIND(find_text,within_text,start_num) | Finds one text value within another. This function is case-sensitive. |
FIXED(number,decimals,no_commas) | Formats a number as text with a fixed number of decimals. |
LEFT(text,num_chars) | Returns the leftmost characters from a text value. |
LEN(text) | Returns the number of characters in a text string. |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.