Capitalize All Letters in a Cell in Google Sheets

4 Parts:

Steps

Video: Capitalize All Letters in a Cell in Google Sheets

Questions and Answers

Comments

You're watching VisiHow. In this video, we are going to show you how to capitalize all of the letters from lowercase to uppercase using Google Sheets.

1. 1
   To capitalize letters, we click cell "B1"

   .

   

   Was this step helpful? Yes | No| I need help
2. 2
   We type "=upper("

   .

   

   Was this step helpful? Yes | No| I need help
3. 3
   We type "A1" or click the "A1" cell

   .

   

   Was this step helpful? Yes | No| I need help
4. 4
   We type ")"

   .

   

   Was this step helpful? Yes | No| I need help
5. 5
   We press "Enter"

   .

   The formula will change the cell contents from lowercase to uppercase.

   

   Was this step helpful? Yes | No| I need help
6. 6
   We can fill the formula down by double-clicking or clicking and dragging the cell

   .

   

   Was this step helpful? Yes | No| I need help

That was how to change all of the letters from lowercase to uppercase using Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

How to change the letters in a cell to upper case, without moving the contents into another cell?

How do I change the letters in a cell, without moving the letters into another cell?. cell A1 has this text in it "The Boat is in THe waTTeR.". I want to change the letters in cell A1 all to upper case.. cell A1 will now look like this "THE BOAT IS IN THE WATER.". Cell A1 has "HeLLo" in it. Everyone shows insert this function into a blank cell =Upper(A1) That blank cell now has "HELLO" in it. I want cell A1 to change to "HELLO". I have tried: Cell A1 has "HeLLo" in it. I type this function =UPPER(A1) into cell H4 or any blank cell. cell H4 now has "HELLO" in it. Right click on cell H4 Left click - Copy Move to cell A1 Right click - Paste special Left click - Paste values only cell A1 now has "#REF!" in it

I simply want cell A1 to have "HELLO" in it.

That is as detailed as I can say it. cell A1 - Big cell A2 - Little cell A3 - Small cell A4 - ConFuSEd How do I make all cells upper case letters? cell A1 - BIG cell A2 - LITTLE cell A3 - SMALL cell A4 - CONFUSED. I think it was caused by: Google sheets does not have a feature like EXCEL does "Convert->Text case as->

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments