Repeats a character string by the given number of copies. New_text is the text which replaces text. Length is the number of characters in text to be replaced. Position is the position within the text where the replacement will begin. Text is text of which a part will be replaced. Any text containing numbers must be enclosed in quotation marks so it is not interpreted as a number and automatically converted to text. To perform further calculations with a number which has been replaced by text, convert it back to a number using the VALUE function. The result of the function is always displayed as text. This function can be used to replace both characters and numbers (which are automatically converted to text). Replaces part of a text string with a different text string. Number is the number of characters in the part of the text.Ĭapitalizes the first letter in all words of a text string. Start is the position of the first character in the text to extract. Text is the text containing the characters to extract. The parameters specify the starting position and the number of characters.
Returns a text segment of a character string. Text is the text whose length is to be determined.Ĭonverts all uppercase letters in a text string to lowercase. Returns the length of a string including spaces. If this parameter is not defined, one character is returned. Number (optional) is the number of characters for the start text. Text is the text where the initial partial words are to be determined. Returns the first character or characters in a text string. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of the current locale setting are displayed. If the parameter is a number not equal to 0, the thousands separator is suppressed. No_thousands_separator (optional) determines whether the thousands separator is used or not. Decimals is the number of decimal places to be displayed. This function can be used to apply a uniform format to a column of numbers. Specifies that a number be displayed with a fixed number of decimal places and with or without a thousands separator.
Position (optional) is the position in the text from which the search starts.įIXED(number decimals no_thousands_separator) Text is the text where the search takes place. The search term can be a number or any string of characters. Where to begin the search can also be defined. Looks for a string of text within another string. The currency format is set in the system settings.Ĭompares two text strings and returns TRUE if they are identical. If no decimals value is specified, all numbers in currency format will be displayed with two decimal places. Decimals (optional) is the number of decimal places. Value is the number to be converted to currency it can be a number, a reference to a cell containing a number, or a formula which returns a number. It may be any positive integer between 2 and 36.Ĭonverts a number to an amount in the currency format, rounded to a specified decimal place. Radix indicates the base of the number system. To differentiate between a hexadecimal number, such as A1 and the reference to cell A1, place the number in quotation marks for example, "A1" or "FACEâ€. text_30 are text passages that are to be combined into one string.Ĭonverts text with characters from a number system to a positive integer in the base radix given. text_30)Ĭombines several text strings into one string.
Openoffice calc function code#
Text is the text for which the code of the first character is to be found.ĬONCATENATE(text_1 text_2. Returns a numeric code for the first character in a text string. Text refers to the text from which to remove all non-printable characters. Removes all non-printing characters from the string. Number is a number between 1 and 255 representing the code value for the character. The number can be a two-digit or three-digit integer number. If the text is shorter than the indicated minimum length, zeros are added to the left of the string.Ĭonverts a number into a character according to the current code table. Minimum_length (optional) is the minimum length of the character sequence that has been created. It may be any positive integer between 2 and 36. Number is the positive integer to be converted. Only the digits 0-9 and the letters A-Z are used. Text is the text that represents a Roman number.Ĭonverts a positive integer to a specified base then into text using the characters from the base's numbering system (decimal, binary, hexadecimal, etc.). Use Calc ’s text functions to search and manipulate text strings or character codes.Ĭalculates the value of a Roman number.
0 kommentar(er)
