How to change text to UPPER, lower, or Sentence Case in Google Sheets

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

Google Sheets has 3 functions that allow you to change any text to UPPER, lower, or Sentence Case.

The formulas are
=upper()
=lower()
=proper()

To give you a quick usage example, let's say you have a form that people are filling out, but they are filling it out with weird text capitalization. Just apply the 3 formulas to capitalize the text any way you wish.

Let me know in the comments what other tech questions or tutorials you want me to make a video about.

Photo by Warren Wong on Unsplash

Рекомендации по теме

Комментарии

To change case (upper, lower, or First letter capital only) on an entire sheet or column, you'll need to download an Add-on. "Change case" is the BEST option. Just Click Add-ons at the top of the window (beside Help) and then Get Add-ons... In the search box, type Case and press Enter. THen, install "Change Case" add-on by Alec Tutin. Hope it helps.!

rayceeaprilperena

Thanks, is there a way to convert texts automatically to all caps on a cell, so that if you type in lower case it convert it to all caps?

MortezaParkook

How do I make this happen for a whole column?

tannervalentine

Is there a formula to change the casing to sentence, with it not capitalizing first alphabet of each word?

ashitha

Sir i need aa code of automatically capital latter when i type a word in Google sheets....help sir

parthvaghela

Some feedback here, your title is misleading as it mentions "sentence case" but shows "title case" instead (proper).

francofigueroa

Thanks for the quick answer! How do I lock in the data so I can delete the old column?

bunnyboops

I'm trying to whenever I write the code "101" in a certain column it substitutes for "Laminate Installation". is that such a thing? would you be able to help me with that?

lucianooliveira