jQuery(function($){ if ($(‘#wpadminbar’).length > 0) { $(‘.et_pb_section_0_tb_header’).css(‘top’, ’32px’); } });

capitalize your text in google sheets

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).


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.
Upper or lower


=LOWER() works the same way! =LOWER(A1) expresses the content in A1 as lowercase.

Try it Yourself

Here is a sample spreadsheet so you can give it a go.

Go Slow Workshop

Want to learn more about Google Sheets or G Suite? Consider joining my Go Slow workshops. They are fully online through Google Classroom. Go Slow workshops are typically 6 weeks to allow you time to learn something and practice it in your classroom before coming back to learn a new thing.



Digiprove sealCopyright secured by Digiprove © 2017

Subscribe to the Alice Keeler Newsletter



WP Twitter Auto Publish Powered By : XYZScripts.com