| Name: |
CHAR |
| Syntax: |
CHAR(<number>) |
| Description: |
Returns the character specified by the code number. |
| Version: |
3.0 |
| Name: |
CLEAN |
| Syntax: |
CLEAN(<text>) |
| Description: |
Remove non-printable characters from a string. |
| Version: |
2.0 |
| Example: |
CLEAN("aXb") Evaluates to "ab" (where 'X' is any non-printable character) |
| Name: |
CODE |
| Syntax: |
CODE(<text>) |
| Description: |
Returns a numeric code for the first character in a text string. |
| Version: |
3.0 |
| Name: |
CONCATENATE |
| Syntax: |
CONCATENATE(<string>, <string>) |
| Description: |
Returns a string which is the two input strings joined together. |
| Version: |
1.0 |
| Example: |
CONCATENATE(“ABC”, “DEF”) Evaluates to “ABCDEF”
CONCATENATE(“ABC”, “”) Evaluates to “ABC” |
| Name: |
DOLLAR |
| Syntax: |
DOLLAR(<number>,[<decimals>]) |
| Description: |
Converts a number to text using a currency format. |
| Version: |
3.0 |
| Name: |
EXACT |
| Syntax: |
EXACT(<text1>, <text2>) |
| Description: |
Checks whether the two strings are exactly the same. Case sensitive. |
| Version: |
3.3 |
| Example: |
EXACT("a", "b") |
| Name: |
FIND |
| Syntax: |
FIND(<text>, <text>[, <number>]) |
| Description: |
Returns the results of the 1-based case sensitive search of the first arguent within the second argument. Both arguments are treated as text. The optional third argument is the 1-based index of the character to start the search on. |
| Version: |
1.3 |
| Example: |
FIND("a", "abc") evaluates to 1
FIND("x", "abc") evaluates to #VALUE!
FIND("B", "abc") evaluates to #VALUE!
FIND("a", "abc", 2) evaluates to #VALUE! |
| Name: |
LEFT |
| Syntax: |
LEFT(<string>, <number>) |
| Description: |
Returns a string which is the first n characters of the input string, n being the second argument. |
| Version: |
1.0 |
| Example: |
LEFT(“ABC”, 1) Evaluates to “A” |
| Name: |
LEN |
| Syntax: |
LEN(<text>) |
| Description: |
Returns the number of characters in a text string. |
| Version: |
3.0 |
| Name: |
LOWER |
| Syntax: |
LOWER(<string>) |
| Description: |
Returns a string which is the input string converted to lower case. |
| Version: |
1.0 |
| Example: |
LOWER(“Abc”) Evaluates to “abc” |
| Name: |
MID |
| Syntax: |
MID(<string>, <number>)
MID(<string>, <number>, <number>) |
| Description: |
Returns the middle n characters of the string passed in. In the first form with two arguments, the second argument specifies the 1-based character that the output string starts from. In the second form with three arguments, the second argument is the 1-based starting point and the third argument is the length of the output string. |
| Version: |
1.0 |
| Example: |
MID(“ABC”, 1) Evaluates to “BC”
MID(“ABC”, 1, 1) Evaluates to “B” |
| Name: |
PROPER |
| Syntax: |
PROPER(<text>) |
| Description: |
Converts a text string to proper case. The first character of each word is upercase. All other characters are lower case. |
| Version: |
3.0 |
| Name: |
REPLACE |
| Syntax: |
REPLACE(<text_old>,<start>,<length>,<text_new>) |
| Description: |
Replaces part of a text string with a different text string. |
| Version: |
3.0 |
| Name: |
REPT |
| Syntax: |
REPT(<text>,<number_times>) |
| Description: |
Repeats text a given number of times. |
| Version: |
3.0 |
| Name: |
RIGHT |
| Syntax: |
RIGHT(<string>, <number>) |
| Description: |
Returns a string which is the last n characters of the input string, n being the second argument. |
| Version: |
1.0 |
| Example: |
RIGHT(“ABC”, 1) Evaluates to “C” |
| Name: |
SEARCH |
| Syntax: |
SEARCH(<text>, <text>[, <number>]) |
| Description: |
Returns the results of the 1-based case insensitive search of the first arguent within the second argument. Both arguments are treated as text. The optional third argument is the 1-based index of the character to start the search on. |
| Version: |
1.3 |
| Example: |
SEARCH("a", "abc") evaluates to 1
SEARCH("x", "abc") evaluates to #VALUE!
SEARCH("B", "abc") evaluates to 2
SEARCH("a", "abc", 2) evaluates to #VALUE! |
| Name: |
SUBSTITUTE |
| Syntax: |
SUBSTITUTE(<text>,<text_old>,<text_new>,[<number_instance>]) |
| Description: |
Replaces existing text with new text in a text string. |
| Version: |
3.0 |
| Name: |
TRIM |
| Syntax: |
TRIM(<text>) |
| Description: |
Remove leading, trailing and duplicate whitespace from a string. |
| Version: |
2.0 |
| Example: |
TRIM(" a b ") Evaluates to "ab" |
| Name: |
UPPER |
| Syntax: |
UPPER(<string>) |
| Description: |
Returns a string which is the input string converted to upper case. |
| Version: |
1.0 |
| Example: |
UPPER(“Abc”) Evaluates to “ABC” |