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.
You must log in to post a comment.