software

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.

=PROPER(A1) if you data were in A1.

quot;Xhawk57quot; wrote:

gt; I have a list of proper nouns (names, addresses, ect.) that is in all capital
gt; letters, I am looking for a formula that would capitalize the first letter of
gt; each word and make the rest of the letters in the word lowercase.
gt;
gt; example: JOHN SMITH 123 MAPLE LN
gt; would become: John Smith 123 Maple Ln
gt;
gt; any help would be greatly apprecitated.

If your string is in A1, use:

=Proper(Lower(A1))--
Please, rate this answer
--
Rogerio Takejame
Americana - Sao Paulo - Brazilquot;Xhawk57quot; wrote:

gt; I have a list of proper nouns (names, addresses, ect.) that is in all capital
gt; letters, I am looking for a formula that would capitalize the first letter of
gt; each word and make the rest of the letters in the word lowercase.
gt;
gt; example: JOHN SMITH 123 MAPLE LN
gt; would become: John Smith 123 Maple Ln
gt;
gt; any help would be greatly apprecitated.

Great, that did it thank you

quot;ewan7279quot; wrote:

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

gt; =Proper(Lower(A1))

What is the point of using the LOWER command here? Why not just
=PROPER(A1) ?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Rogerio Takejamequot; gt;
wrote in message
...
gt; If your string is in A1, use:
gt;
gt; =Proper(Lower(A1))
gt;
gt;
gt; --
gt; Please, rate this answer
gt; --
gt; Rogerio Takejame
gt; Americana - Sao Paulo - Brazil
gt;
gt;
gt; quot;Xhawk57quot; wrote:
gt;
gt;gt; I have a list of proper nouns (names, addresses, ect.) that is
gt;gt; in all capital
gt;gt; letters, I am looking for a formula that would capitalize the
gt;gt; first letter of
gt;gt; each word and make the rest of the letters in the word
gt;gt; lowercase.
gt;gt;
gt;gt; example: JOHN SMITH 123 MAPLE LN
gt;gt; would become: John Smith 123 Maple Ln
gt;gt;
gt;gt; any help would be greatly apprecitated.
Indeed! It was my fault. The Proper function do all the work.

--
Rogerio Takejame
Americana - Sao Paulo - Brazilquot;Chip Pearsonquot; wrote:

gt; gt; =Proper(Lower(A1))
gt;
gt; What is the point of using the LOWER command here? Why not just
gt; =PROPER(A1) ?
gt;
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Rogerio Takejamequot; gt;
gt; wrote in message
gt; ...
gt; gt; If your string is in A1, use:
gt; gt;
gt; gt; =Proper(Lower(A1))
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Please, rate this answer
gt; gt; --
gt; gt; Rogerio Takejame
gt; gt; Americana - Sao Paulo - Brazil
gt; gt;
gt; gt;
gt; gt; quot;Xhawk57quot; wrote:
gt; gt;
gt; gt;gt; I have a list of proper nouns (names, addresses, ect.) that is
gt; gt;gt; in all capital
gt; gt;gt; letters, I am looking for a formula that would capitalize the
gt; gt;gt; first letter of
gt; gt;gt; each word and make the rest of the letters in the word
gt; gt;gt; lowercase.
gt; gt;gt;
gt; gt;gt; example: JOHN SMITH 123 MAPLE LN
gt; gt;gt; would become: John Smith 123 Maple Ln
gt; gt;gt;
gt; gt;gt; any help would be greatly apprecitated.
gt;
gt;
gt;