PROPER Function (Functions in Excel)
Original Text | Proper | |
alan jones | Alan Jones | =PROPER(C4) |
bob smith | Bob Smith | =PROPER(C5) |
caRol wILLIAMS | Carol Williams | =PROPER(C6) |
cardiff | Cardiff | =PROPER(C7) |
ABC123 | Abc123 | =PROPER(C8) |
What Does It Do ? |
This function converts the first letter of each word to uppercase, and all subsequent letters |
are converted to lower case. |
Syntax |
=PROPER(TextToConvert) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment