Buzz
The PROPER function in Excel changes the first character of each word in a string to uppercase. This function has widespread practical applications. To gain a better understanding of its syntax and usage, please follow the article below.
PROPER Function and Examples
How to Use Excel's PROPER Function: Illustrated Examples
Syntax: PROPER(text)
Where: Text is a string or a reference to a string that needs to be converted
Consider an Example
Example 1: You can transform a string like this: = PROPER(“free download”)
After pressing Enter, the string will become “ Free Download”
Example 2: Referring to the string needing conversion. We have a list like this:
I want to convert the first characters of “Full Name” to uppercase, I do as follows:
+ In cell E5, type as follows E5=PROPER(C5) then press Enter to get the result.
+ Use drag-and-drop with the mouse to apply to the remaining cells
So now you know how to use the PROPER function in Excel to capitalize the first letter of each word in a string. Additionally, you can explore more about Capitalizing the First Letter in a Spreadsheet
