Examples

Numbers or punctuation characters inside a text string are unaffected: If a numeric value is given to PROPER, number formatting is removed. For example, if cell A1 contains the date June 26, 2021, date formatting will be lost and PROPER will return a date serial number as text:

Use the LOWER function to convert text to lowercase, use the UPPER function to convert text to uppercase, and use the PROPER function to capitalize the words in a text string.

Notes

Use PROPER to capitalize each word in a given string. All words in a text string are capitalized. Numbers and punctuation characters are not affected. Number formatting is removed from standalone numeric values.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.