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?
[Solved] Format uppercase to lowercase with capital letter
[Solved] Format uppercase to lowercase with capital letter
Last edited by Hagar Delest on Sat Jun 28, 2008 11:59 am, edited 1 time in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
Re: format uppercase to lowercase with capital letter
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))
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
Re: format uppercase to lowercase with capital letter
If course, great, thanks!
Re: format uppercase to lowercase with capital letter
=PROPER(A1)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: format uppercase to lowercase with capital letter
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.
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.