Calc Guide

Syntax Description
equal to 0, the thousands separator is
suppressed. If the parameter is equal to 0 or if
it is missing altogether, the thousands
separators of the current locale setting are
displayed.
LEFT(text; number) Returns the first character or characters in a
text string. Text is the text where the initial
partial words are to be determined. Number
(optional) is the number of characters for the
start text. If this parameter is not defined, one
character is returned.
LEN(text) Returns the length of a string including spaces.
Text is the text whose length is to be
determined.
LOWER(text) Converts all uppercase letters in a text string
to lowercase. Text is the text to be converted.
MID(text; start; number) Returns a text segment of a character string.
The parameters specify the starting position
and the number of characters. Text is the text
containing the characters to extract. Start is
the position of the first character in the text to
extract. Number is the number of characters
in the part of the text.
PROPER(text) Capitalizes the first letter in all words of a text
string. Text is the text to be converted.
REPLACE(text; position;
length; new_text)
Replaces part of a text string with a different
text string. This function can be used to replace
both characters and numbers (which are
automatically converted to text). The result of
the function is always displayed as text. To
perform further calculations with a number
which has been replaced by text, convert it
back to a number using the VALUE function.
Any text containing numbers must be enclosed
in quotation marks so it is not interpreted as a
number and automatically converted to text.
Text is text of which a part will be replaced.
Position is the position within the text where
the replacement will begin. Length is the
number of characters in text to be replaced.
New_text is the text which replaces text..
REPT(text; number) Repeats a character string by the given
number of copies. Text is the text to be
Appendix B Description of Functions 477