Capitalize Your Text in Google Sheets
Sometimes you need your text in capital letters (or all lowercase). If your information is in a spreadsheet you can use formulas to make your text in uppercase (or lowercase).
=UPPER()
In a spreadsheet cell type =UPPER( and click on the cell that contains text that you want in uppercase. Press enter. =UPPER(A1) will express what is in A1 to uppercase.
=LOWER()
=LOWER() works the same way! =LOWER(A1) expresses the content in A1 as lowercase.
Paste Special
The problem with using a formula for =UPPER() or =LOWER() is that you now have the information in your spreadsheet twice. Highlight the new values. Use Control C to copy. Immediately use Control Shift V to paste special overtop of where the formulas are. This will strip the formulas and leave only your capitalized text. You can now delete the original non capitalized text.
Try it Yourself
Here is a sample spreadsheet so you can give it a go.
Want More Help with This? Become a Premium Member
Google Docs Google Play App Store Install
If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install
Navigate Google Forms Sections
If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections
BETTER – Print Google Form Quiz
Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…
Something Fun for the End of the Year
What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…
Collaborate with Students – reuse TemplateTab
Reuse TemplateTab to collaborate with students and have less paperwork to grade.