Tired of manually fixing text case in your spreadsheets? This quick tip shows you how to change text to UPPERCASE, lowercase, or Title Case in seconds — whether you’re using Excel or LibreOffice Calc.
💡 Excel Tip
Use these formulas to change case:
=UPPER(A1) → Converts the text in cell A1 to ALL CAPS
=LOWER(A1) → Converts the text in cell A1 to lowercase
=PROPER(A1) → Converts the text in cell A1 to Title Case
💡 LibreOffice Calc Tip
Highlight your cells and press
Shift + F3 to cycle through Title Case, Sentence case, UPPERCASE, and lowercase.
Which spreadsheet software do you use most — Excel, LibreOffice Calc, or something else?
Share your favorite tips in the comments below!
One response
-
This tip is on our facebook page as well if you want to check it out there:
https://web.facebook.com/ChipShakeIT
Leave a Reply