[Solved] Format uppercase to lowercase with capital letter

[cord]

I have a column with names written in capital letters and want to make it lower letters with capital first letter.
Using Format - Change to uppercase/lowercase makes all letters either lower or upper but not with capital first letter.
Is there any way to do this?

[TerryE]

You can insert a temp column next to it and (assuming that you've inserted B after A which you want in Title case) then SET B1 to the formula

• =UPPER(LEFT(A1;1))&LOWER(MID(A1;1;256))

then copy B and Past Special->Strings onto A. Then delete B.

[cord]

If course, great, thanks!

[Villeroy]

=PROPER(A1)

[TerryE]

PROPER will uppercase the first letter of all words in the Cell not just the first. If this is what you want, then its the most elegant solution.