How to change text case in Google Sheets with UPPER LOWER and PROPER

preview_player
Показать описание

In this video I show you three different ways to change the case of text in Google Sheets, by using formulas (UPPER, LOWER, PROPER). You will learn to make text lowercase, uppercase, and more.
Рекомендации по теме
Комментарии
Автор

What if you want first letter to be capital

allanwambia
Автор

This explanation was useful. What can next be done to delete the original data column? When I try to do so, the new column also deletes. I realize the new column is sourcing off the original one, but I don't want or need both columns to be retained - I just want the new "fixed" data. Thanks for guidance on this.

bethsavage
Автор

hi how can u apply this on a whole coloumn with data in it

muhammadsheroze
Автор

Hello! I have a google sheet that has a mix of Upper and lower case text, a real mess! So What I want to do is basically, select all and capitalize! and hopefully force any future input to be in capitals too, is there a way of doing this? Thanks!

Iammikelovin