Change to UPPER CASE

Text > Change to UPPER CASE

This utility makes all text in selected cells uppercase. 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

Launch this tool

Click YLC Utilities > Text > Change to UPPER CASE :

Excel:

LibreOffice Calc:

Do you recognize any of these situations?

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

Just select the cells and then use the following tool:

YLC Utilities » Text » Change to UPPER CASE

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel (Calc) , the amount 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 are opened in Excel (LibreOffice Calc) .