Brother International PDP350CJ Owner's Manual - English - Page 400

Function Description Example LENGTH (string) Returns the numberof characters in a string including characters, punctuation marks, and spaces enclosed in quotation marks. =LENGTH(Now is the time.") returns 16. LOWER (string) Convertsupper case characters to lower case. =LOWER(SUMMER,1993") returns summer,1993. MID (string, start, num) Returns the number of characters (num) in the middle of a string, beginning at the position you indicate (start). The first character in the string is in position 0. A reference to cells containing values produces an error. The RIGHT function extracts characters beginning with the rightmostcharacter, LEFT extracts beginning with the leftmost character, and MID extracts from an internal position. For more information, see the descriptions of the LEFT and RIGHT functions. =MID(The United States",4,6) returns United". PROPER (string) Capitalizes the first letter of every word and the first letter following any non-letter character. PROPER converts all other characters to lower case. =PROPER(Now is the time") returns Now Is The Time". =PROPER(1993 BUDGET") returns 1993 Budget". REPEAT (string, num) Repeats a string a specified number of times. If =REPEAT(Ha",6) returns HaHaHaHaHaHa. num is zero, REPEAT returns an empty string. =REPEAT(Ha ",6) returns Ha Ha Ha Ha Ha Ha. REPLACE (original, start, num, replace) Replaces matching characters in a string with a specified string. Original is the text string in which you want to replace characters. Start is the first character in the original string that you want to replace. The first character in the string is 0. Num is the number of characters in the original string that you want to replace. Replace is the replacement string. You can use more or fewer replacement characters than are replaced, in the original string. =REPLACE(1992",3,1,"3") returns 1993". =REPLACE(Now is the time for all good men",29,3,"people") returns Now is the time for all good people". RIGHT (string, num) Returns the characters in the rightmost position in a string. RIGHT returns to the right that number of leftmost characters. The first character in the string is in position 0. A reference to cells containing values produces an error. While RIGHT extracts characters beginning with the rightmost character, LEFT extracts beginning with the leftmost character, and MID extracts from an internal position. For more information, see the descriptions of the LEFT and MID functions. =RIGHT(Section A",1) returns A". =RIGHT(Number of Items, 25",2) returns 25. STRING (value, N) Converts values to a string using N decimal =STRING(245.356,1) returns 245.4". places. N can be a number from 0 through 15. TRIM (string) Removesextra spaces before and after words =TRIM( Cleveland, Ohio ) returns and between lines of text in a string. Cleveland, Ohio". UPPER (string) Converts a string to upper case. =UPPER(usa") returns USA. VALUE (string) Convertsa number in string form to a value =VALUE(1.75") returns 1.75. Appendix 373