The PROPER function in Excel is used to capitalize the first letter of each word in a given text string, and convert all other letters to lowercase. Here’s how to use the PROPER function in Excel:
- Start by selecting the cell where you want the output to appear.
- Type “=PROPER(” into the cell.
- Within the parenthesis, type the reference to the cell or the text string you want to capitalize the first letter of each word.
For example, if you have a name in cell A1 and want to capitalize the first letter of each word in that name, you can use the following formula in a different cell:
The output will display the name with the first letter of each word capitalized and all other letters in lowercase.
Note that the PROPER function does not capitalize the first letter of a word following a hyphen or an apostrophe. If you want to capitalize those letters as well, you may need to use a combination of the PROPER function with other functions like SUBSTITUTE, UPPER, or LOWER.