proper

 The PROPER function in Excel is used to convert text to proper case, where the first letter of each word is capitalized, and the rest of the letters are in lowercase. Below are 10 examples of how you can use the PROPER function, including sample data and formulas.

Example 1: Basic Usage

Data: john doe
Formula: =PROPER("john doe")
Result: John Doe

Example 2: Converting a Column of Names

Data:

A
john doe
jane smith
alice johnson

Formula: =PROPER(A1) (drag down)
Result:

B
John Doe
Jane Smith
Alice Johnson

Example 3: Combining with CONCATENATE

Data:

A	B
john	doe
jane	smith

Formula: =PROPER(CONCATENATE(A1, " ", B1))
Result: John Doe

Example 4: Combining with TRIM

Data: john doe
Formula: =PROPER(TRIM(" john doe "))
Result: John Doe

Example 5: Converting Text in a Sentence

Data: the quick brown fox
Formula: =PROPER("the quick brown fox")
Result: The Quick Brown Fox

Example 6: Handling Mixed Case Text

Data: jOhN dOE
Formula: =PROPER("jOhN dOE")
Result: John Doe

Example 7: Combining with LEFT and RIGHT Functions

Data: john doe
Formula: =PROPER(LEFT("john doe", 4)) & PROPER(RIGHT("john doe", 3))
Result: JohnDoe

Example 8: Using PROPER with UPPER and LOWER

Data: JOHN DOE
Formula: =PROPER(LOWER("JOHN DOE"))
Result: John Doe

Example 9: Applying PROPER to a Range of Cells

Data:

A
john doe
JANE SMITH
alice johnson

Formula: =PROPER(A1:A3) (array formula, use Ctrl+Shift+Enter)
Result:

B
John Doe
Jane Smith
Alice Johnson

Example 10: Combining with SUBSTITUTE

Data: john_doe
Formula: =PROPER(SUBSTITUTE("john_doe", "_", " "))
Result: John Doe

Summary

The PROPER function is versatile and can be combined with other Excel functions to manipulate and format text data effectively. Whether you're working with single cells, ranges, or combining it with other text functions, PROPER can help ensure your text is consistently formatted in proper case.