Upper Case Letters to First Letter Upper, Remaining Letters Lower

[SueW]

How is this done in Excel 2007?

 

[Jim Thomlinson]

Use the proper function.

=Proper(A1)

 

[KC hotmail com>]

The formula =PROPER(A1) will make every first letter of each word upper case
and the rest of each word lower case. A1 is the cell you want changed to
upper/lower.

So QUICK BROWN FOX becomes Quick Brown Fox.

If you wanted "Quick brown fox," that cannot be done via formula. A period
may or may not be the end of a sentence, and certain words in the middle of a
sentence may need to be capitalized, so this is just too complicated. Excel
can do =UPPER, =LOWER, or =PROPER.

 

[Jim Thomlinson]

=upper(left(A1), 1) & lower(mid(A1, 2, 100)
Will turn generate "Quick brown fox"

 

[KC hotmail com>]

Yep, sure
I was trying to point out that if it's not just one sentence, or if it has
periods in a single sentence, or if something in the middle is supposed to be
capitalized, that would not be accommodated. I should have provided a better
example, like "Dr. Jones thought tumors, cysts, etc. would be easy to deal
with."

 

[SueW]

I cannot get this to repeat in the cells I need it to. I can get the formula
to work in one cell, but I have 35,951 entries I need to change from all
upper to Upper, lower, and they each contain a different last name.

 

[Fred Smith]

You just need to copy the formula down the column.

Assume your names are in column A, with no blank rows.

Enter the formula you were given in B1.
Now, double-click on the fill handle (the small square at the bottom right
of the cell).
Voila, the entire column will be populated with proper names.

Regards,
Fred

 

[Gord Dibben]

=PROPER(LEFT(A1,1))&LOWER(MID(A1,2,255))

Returns............Quick brown fox


Gord Dibben MS Excel MVP