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