TOP
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 :
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 capitalize LO Calc? I have columns of names and addresses - some are bottom and some are top - how do I change the bottom to top - ie how can I make these letters capital? thank you
- I copied and pasted text from different documents to create one. Some of them are capitalized and some are not. I would like to capitalize on all this.
- 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 data must be in upper case. Is there a quick way to convert all text?
Just select the cells and then use this tool:
YLC Utilities » Text » Change to UPPER CASE
How much time will it save?
Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LO Calc, the amount of data you are working with, and how often you use the tool.
Download
If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .
Additional keywords for this tool:
Change case, Caps, All caps, Capitals, In capitals, Upper case, upper case in upper case, convert text from lower case to all caps without retyping