| function name |
Function Description |
syntax |
| ASC |
string of full-width (double-byte) English letters changed to half-width (single-byte) characters. |
ASC (text) |
| CHAR |
return code corresponds to the number of characters, CHAR function can be other types of computer files in the code is converted to characters. |
CHAR (number) |
| CLEAN |
can not print the text to delete characters. From other applications use input string CLEAN function to remove the current operating system which contains not printable characters. For example, you can delete data files usually appear in the head or tail, can not print the low-level computer code. |
CLEAN (text) |
| CODE |
to return to the text string in the first number of code characters. Return code corresponds to the current use of the computer character set. |
CODE (text) |
| CONCATENATE |
will be a number of text strings into one text string. |
CONCATENATE (text1, text2 ,...) |
| DOLLAR |
in accordance with the currency format specified will be rounded to the nearest decimal digits and converted into text. |
DOLLAR or RMB (number, decimals) |
| EXACT |
the function tests whether two strings are identical. If they are identical, then return TRUE; Otherwise, return FALSE. EXACT is case-sensitive function can be, but ignores the differences in format. EXACT function to test the use of input text files. |
EXACT (text1, text2) |
| FIND |
FIND text string used to search for other (within_text) within the text string (find_text), and characters from the beginning of the first within_text to return to the starting position find_text number. |
FIND (find_text, within_text, start_num) |
| FIXED |
specified number of decimal places by rounding to the use of periods and commas to the number of decimal format to format and return the results of the form of text strings. |
FIXED (number, decimals, no_commas) |
| JIS |
string of half-angle (single-byte) English letters or katakana changed to full-width (double-byte) characters. |
JIS (text) |
| LEFT |
LEFT specified based on the number of characters to return to the text of the first in a string or the first few characters.
LEFTB based on specified number of bytes to return to the text of the first in a string or the first few characters. Double-byte characters for this function. |
LEFT (text, num_chars)
LEFTB (text, num_bytes) |
| LEN |
LEN to return to the text string of characters.
LENB to return to the text string used to represent characters in the number of bytes. Double-byte characters for this function. |
LEN (text)
LENB (text) |
| LOWER |
a text string in all uppercase letters converted to lowercase letters. |
LOWER (text) |
| MID |
MID to return to the text string in the specified location from the beginning of the specified number of characters, the number specified by the user.
MIDB return to the text string in the specified location from the beginning of the specified number of characters, the number specified by the user. Double-byte characters for this function. |
MID (text, start_num, num_chars)
MIDB (text, start_num, num_bytes) |
| PHONETIC |
extract the text strings in the alphabet (furigana) characters. |
PHONETIC (reference) |
| PROPER |
will be the first letter of the text string and any non-alphanumeric characters after the first letter uppercase conversion. The rest of the letters will be converted to lowercase. |
PROPER (text) |
| REPLACE |
REPLACE and other text strings based on the number of characters specified in the replacement of a part of the text string in the text.
REPLACEB the use of other text string and in accordance with the number of characters specified in the replacement of a part of the text string in the text. This function is used for double-byte characters. |
REPLACE (old_text, start_num, num_chars, new_text)
REPLACEB (old_text, start_num, num_bytes, new_text) |
| REPT |
in accordance with a given number of repeated text. REPT function can be repeated continuously to a text strings, and to fill the cell. |
REPT (text, number_times) |
| RIGHT |
RIGHT according to the number of characters specified in the text string to return to the last one or more characters.
RIGHTB according to the number of characters specified in the text string to return to the last one or more characters. Double-byte characters for this function. |
RIGHT (text, num_chars)
RIGHTB (text, num_bytes) |
| SEARCH |
SEARCH to return to the first time from the beginning of start_num to find a particular string of text characters or a specific location on the number of characters. SEARCH can be used to identify the text string of characters or strings of text in other locations, so that you can use the MID or REPLACE functions to change the text.
SEARCHB also in other text string (within_text) to find the text string (find_text), and return to the starting position find_text number. This result is based on the characters used for each number of bytes from the beginning of start_num. Double-byte characters for this function. In addition, can also be used in other text string FINDB search text string. |
SEARCH (find_text, within_text, start_num)
SEARCHB (find_text, within_text, start_num) |
| SUBSTITUTE |
used in the text string new_text alternative old_text. If you need to replace a specified text string in the text, use the function SUBSTITUTE; If you need to replace a specified text string in any position the text, use the function REPLACE. |
SUBSTITUTE (text, old_text, new_text, instance_num) |
| T |
will be converted to text values. |
T (value) |
| TEXT |
value is converted to a digital format specified text. |
TEXT (value, format_text) |
| TRIM |
In addition to a single space between words, the removal of all the spaces in the text. From other applications with irregular access to the text box, you can use the function TRIM. |
TRIM (text) |
| UPPER | National Cheng Kung University
convert text written form. |
UPPER (text) |
| VALUE |
will represent the number of text strings to digital. |
VALUE (text) |
| WIDECHAR |
single-byte characters will be converted to double-byte characters. |
WIDECHAR (text) |
| YEN | гд
use (Japanese) currency format will be converted into digital text, and specify the number of the nearest location. |
YEN (number, decimals) |
