PROPER()
Syntax. PROPER(text)
Definition. This function converts the first character of all words in a string to uppercase and all other characters to lowercase.
Arguments
text (required). The text string enclosed in quotation marks, a formula that returns text, or the reference to the cell that contains the text you want to convert to proper case
Background. Many systems import data in uppercase. Using the PROPER() function allows you to convert the data to normal text.
You can also use this function for names with a hyphen. If you pass numeric values, the PROPER() function works in the same way as the UPPER() function.
Examples. Assume that the text in an imported list consists of all uppercase letters. You want to convert the text to the correct ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
