Easily Change Capitalization or Case of Text in LibreOffice Calc Cell

This quick tutorial demonstrates how you can change the case of any text in LibreOffice Calc Cell.

Changing case is a trivial thing. I mean, you can always change it via your Keyboard’s CAPS LOCK Key. But how about changing it via a formula, probably when you do not have control over keyboard. Or, imagine changing the case for thousands of rows. This article explains on how you can change case in cells.

It’s really very simple.

Change case of text in LibreOffice Calc Cell

Change to Upper Case

To change case to upper case, use the UPPER function. It takes the text to be converted as argument.

The Syntax is below

=UPPER(your text)

It takes the argument of your target text which need to be converted to uppercase. In the below example, it takes the string in cell B2 and convert it to upper case. You can also enter the string directly to the function itself.

Change to Lower Case

To change a text or string in any cell to lower case, use the LOWER function. It also takes the text to be converted as input.

The syntax is below:

=LOWER(your text)

The LOWER function is exactly the same as the UPPER function. It takes the string as input and converts it entirely to lowercase. See the same example below.

Change to Title Case

The Title Case conversion is also possible using the Calc formula. The Title Case is nothing but each of the first letter of words are capital. So, to do that use the PROPER() function. This function can make the title case of any text in any cell.

=PROPER(your text)

I hope these two simple function helps you to convert any text or string in any cell to upper case or lower case in LibreOffice Calc. Drop a comment if you face difficulties or have any question.

Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.