Post published:26/05/2011 Post category:OpenOffice / LibreOffice / Microsoft Office If you have a column with capitalized text and you want to convert it to lowercase but with the first letter capitalized try the following code to a new column: CONCATENATE(UPPER(LEFT(C2;1)) ;LOWER(RIGHT(C2;LEN(C2)-1))) 1 CONCATENATE(UPPER(LEFT(C2;1)) ;LOWER(RIGHT(C2;LEN(C2)-1)))