/

Easily Change Capitalization or Case of Text in LibreOffice Calc Cell

808 views

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.

UPPER Function
UPPER Function

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.

LOWER Function
LOWER Function

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.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x