PROPER ()
This function converts the first letter of each word to
uppercase, and all subsequent letters are converted to lower case.
Best view in desktop mode.
A
|
B
|
C
|
|
1
|
Original Text
|
Proper Text
|
|
2
|
alan jones
|
Alan Jones
|
=PROPER(A2)
|
3
|
bob smith
|
Bob Smith
|
=PROPER(A3)
|
4
|
caRol wILLIAMS
|
Carol Williams
|
=PROPER(A4)
|
5
|
cardiff
|
Cardiff
|
=PROPER(A5)
|
6
|
ABC123
|
Abc123
|
=PROPER(A6)
|
Syntax
=PROPER(TextToConvert)
Formatting
No special
formatting is needed.
No comments:
Post a Comment