capital letters to lowercase
Great, that did it thank you
"ewan7279" wrote:
=PROPER(A1) if you data were in A1.
"Xhawk57" wrote:
I have a list of proper nouns (names, addresses, ect.) that is in all capital
letters, I am looking for a formula that would capitalize the first letter of
each word and make the rest of the letters in the word lowercase.
example: JOHN SMITH 123 MAPLE LN
would become: John Smith 123 Maple Ln
any help would be greatly apprecitated.
|