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. 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-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.