Text(Microsoft Excel Functions)
Contents
Functions.
Function to modify a string.
| Function | Importance | Description |
|---|---|---|
| LEFT MID RIGHT | High | Extracts a portion of a string by specifying the number of characters . |
| LEFTB MIDB RIGHTB | Low | Extracts a portion of a string by specifying the number of bytes from the beginning. |
| SUBSTITUTE | High | Replace the specified string. |
| REPLACE | Middle | Replace specified character position & number of characters with specified string. |
| TRIM | Middle | Remove unnecessary spaces between and before and after words, leaving one space between words. |
| CLEAN | Middle | Delete characters that cannot be printed. |
| CONCATENATE | Low | Concatenate strings (old version) |
| CONCAT | High | Concatenate strings. |
| TEXT | Middle | Get a string with display format code (user-defined format) applied to a number or date. |
| VALUE | Middle | Converts a number or date/time entered as a string to a number (serial value of date/time). |
| TEXTJOIN | High | Concatenate strings by specifying the delimiter. |
| FIXED | Middle | Converts a number to a comma-separated formatted string, rounded to the specified number of digits. |
| ASC | Middle | Converts full-width characters to half-width characters. |
| JIS | Middle | Converts half-width characters to full-width characters. |
| NUMBERVALUE | Middle | Converts strings of numeric notation (decimal points and commas) from various languages into numbers. |
| REPT | Middle | Repeat the specified string a specified number of times. |
| UNICHAR | Low | Get the Unicode character corresponding to the number. |
| UNICODE | Low | Get the Unicode number corresponding to a character. |
| TEXTBEFORE | High | Get text up to the specified text. |
| TEXTAFTER | High | Get text after the specified text. |
| TEXTSPLIT | High | Divides text into cells based on a specified character. |
| PROPER | High | Only the first letter is converted to uppercase. |
| UPPER | High | Convert to upper case. |
| LOWER | High | Convert to lower case. |
Function to get information from a string.
| Function | Importance | Description |
|---|---|---|
| FIND | High | Find the position of the specified string. |
| FINDB | Low | Searches for the position (in bytes) of the specified string. |
| SEARCH | High | Find the position of the specified string. |
| LEN | High | Get the length (number of characters) of a string. |
| LENB | Low | Get the length (in bytes) of a string. |
| CODE | Middle | Get the numeric code of a character. |
| CHAR | Middle | Get the character corresponding to the numeric code. |
| EXACT | High | Compare if two strings are the same. |
Others
| Function | Importance | Description |
|---|---|---|
| ARRAYTOTEXT | High | Convert array (cell range) to text |