Change to UPPER CASE

Text > Change to UPPER CASE

This utility makes all text in selected cells upper case. For example, «this is a test» becomes «THIS IS A TEST».

This can be useful, for example, for city names, article codes, and postal codes.

Screenshot

Running this tool

Click YLC Utilities > Text > Change to UPPER CASE:

Do you recognize any of these situations?

• How can I select all cells or a group of cells and make all text capital letters?
• How to make capital letters in Excel (Calc)? I have columns with names and addresses - some in lower case and others in upper case form - how do I change lower case to upper case - that is, how can I make these letters capital? Thank you
• I copied and pasted text from different documents to create one. Some are in capital letters and others are not. I would like to capitalize all of it.
• How can I format cells so that ALL letters in a word are capital?
• I created a large spreadsheet, and now for legal reasons all data must be in upper case. Is there a quick way to convert all text?

Just select the cells, then use this tool:

YLC Utilities » Text » Change to UPPER CASE

How much time will this save?

By using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use Excel (Calc), the volume of data you work with, and how often you use this tool.

Download extension

You can use the utility Change to UPPER CASE by installing the extension YLC Utilities.

After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).