PROPER

Used only in ReliaSoft Workbooks

Description: Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. It converts all other letters to lowercase letters.

Syntax: PROPER(Text)

  • Text is text enclosed in quotation marks, a formula that returns text or a reference to a cell containing the text you want to partially capitalize.

Example:

  • PROPER("this is a TITLE") = "This Is A Title"
  • PROPER("2-cent's worth") = "2-Cent'S Worth"
  • PROPER("76BudGet") = "76Budget"

Related Topics and Links