What is the PROPER Function
The PROPER function capitalizes the first letter of each word in a text string and converts all other letters to lowercase. It is useful for formatting names and titles.
Formula: =PROPER(text)
Practical Example 1
A2 contains md. saiful islam.
Type: =PROPER(A2)
Result: Md. Saiful Islam
Practical Example 2
Format a product name.
Type: =PROPER(product name here)
Result: Product Name Here
Practical Example 3
Combine with TRIM for clean formatted names.
Type: =PROPER(TRIM(A2))
Result: clean formatted name
When to Use It
PROPER is used for formatting names, for title casing addresses, for cleaning imported text, and for any formula where you need proper capitalization.