Related Topics: | ||
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"
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.