Apple iWork '09 - Manual (Page 317)

Chapter 11 Text Functions 317
Examples
=MID(”lorem ipsum dolor sit amet”, 7, 5) returns “ipsum”.
=MID(”1234567890”, 4, 3) returns “456”.
=MID(”shorten”, 5, 20) returns “ten”.
Related Topics
For related functions and additional information, see:
“LEFT” on page 314
“RIGHT” on page 319
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
PROPER
The PROPER function returns a string where the first letter of each word is uppercase
and all remaining characters are lowercase, regardless of the case of the characters in
the specified string.
PROPER(source-string)
 source-string: A string. source-string is a string value.
Usage Notes
Any character following a nonalphabetic character, except apostrophe (‘), is Â
treated as the first letter in a word. So, for example, any letter following a hyphen is
capitalized.
Examples
=PROPER(”lorem ipsum”) returns “Lorem Ipsum”.
=PROPER(”lorem’s ip-sum”) returns “Lorem’s Ip-Sum”.
=PROPER(”1a23 b456”) returns “1A23 B456”.
Related Topics
For related functions and additional information, see:
“LOWER” on page 316