Functions to Remove Extra Characters | CLEAN | Removes all non-printable characters from a supplied text string | TRIM | Removes duplicate spaces, and spaces at the start and end of a text string |
Functions to Convert Excel Data Types | BAHTTEXT | Converts a number, plus the suffix "Baht" into Thai text | DOLLAR | Converts a supplied number into text, using a currency format | FIXED | Rounds a supplied number to a specified number of decimal places, and then converts this into text | TEXT | Converts a supplied value into text, using a user-specified format | VALUE | Converts a text string into a numeric value |
Functions to Convert Between Upper & Lower Case | LOWER | Converts all characters in a supplied text string to lower case | PROPER | Converts all characters in a supplied text string to proper case (i.e. letters that do not follow another letter are upper case and all other characters are lower case) | UPPER | Converts all characters in a supplied text string to upper case |
Converting Between Characters & Numeric Codes | CHAR | Returns the character that corresponds to a supplied numeric value | CODE | Returns the numeric code for the first character of a supplied string |
| Replacing / Substituting Parts of a Text String | REPLACE | Replaces all or part of a text string with another string (from a user supplied position) | SUBSTITUTE | Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text |
Cutting Up & Piecing Together Text Strings | CONCATENATE | Joins together two or more text strings | LEFT | Returns a specified number of characters from the start of a supplied text string | MID | Returns a specified number of characters from the middle of a supplied text string | RIGHT | Returns a specified number of characters from the end of a supplied text string | REPT | Returns a string consisting of a supplied text string, repeated a specified number of times |
Information Functions | LEN | Returns the length of a supplied text string | FIND | Returns the position of a supplied character or text string from within a supplied text string (case-sensitive) | SEARCH | Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive) | EXACT | Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive) | T | Tests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string. |
|
No comments:
Post a Comment