Difference between revisions of "Documentation/How Tos/Calc: PROPER function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(See also:)
Line 17: Line 17:
  
 
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
 
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 16:04, 13 September 2008


PROPER

returns text with words in lowercase after a capitalised first letter.

Syntax:

PROPER(text)

returns text with the first character of each word capitalised, and other characters in lower case.

Example:

PROPER("gooD morNINg")

returns Good Morning.

See also:

LOWER, UPPER

Text functions

Functions listed alphabetically, Functions listed by category

Personal tools