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."
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"KC" wrote:

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"SueW" wrote:

How is this done in Excel 2007?