Owner manual

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 rst letter of each word is uppercase

and all remaining characters are lowercase, regardless of the case of the characters in

the specied 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 rst 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”.