sodcalculator

10 Tech How-To

Convert Text Case in Google Sheets: A How-To

Guide 10-45390 · Updated · Step by step

This guide shows you how to change text from uppercase to lowercase, lowercase to uppercase, or to title case directly inside Google Sheets. You’ll learn the built-in functions and a few tricks for handling partial text and special cases. No prior experience with formulas is needed, just a Google account and a spreadsheet with some text.

What You’ll Need

  • A Google account (free) to access Google Sheets.
  • A spreadsheet containing the text you want to convert.
  • Basic familiarity with clicking cells and typing in the formula bar.

Step-by-Step

  1. Open your Google Sheet. Go to sheets.google.com and open the file that contains the text you wish to convert.
  2. Identify the cell with the text. Click on the cell that holds the text you want to change. For example, if cell A1 contains “hello WORLD”, you’ll be converting that.
  3. Choose an empty cell for the result. Click on an empty cell where you want the converted text to appear. For instance, cell B1 is a good choice. This keeps your original data intact.
  4. Type the formula for lowercase. To convert text to all lowercase, type =LOWER(A1) into the empty cell and press Enter. The result will show “hello world”.
  5. Type the formula for uppercase. To convert text to all uppercase, type =UPPER(A1) into another empty cell and press Enter. The result will show “HELLO WORLD”.
  6. Type the formula for title case. To convert text to title case (first letter of each word capitalized), type =PROPER(A1) into a cell and press Enter. The result will show “Hello World”.
  7. Copy the formula down (optional). If you have a column of text in A2, A3, A4, etc., click on the cell with the formula (e.g., B1). You’ll see a small blue square in the bottom-right corner of the cell. Click and drag that square down to fill the formula for the other rows.
  8. Use the result as a value. If you want to replace the original text with the converted version, copy the cell with the formula (Ctrl+C or Cmd+C), then right-click on the original cell and choose “Paste special” > “Paste values only”. This removes the formula and keeps just the text.
  9. Handle partial text with LEFT or RIGHT. If you only want to convert part of a cell, combine functions. For example, to uppercase only the first 3 characters of A1, use =UPPER(LEFT(A1,3)). To lowercase the last 4 characters, use =LOWER(RIGHT(A1,4)).
  10. Combine with other text. You can add text around your converted text. For instance, to add a prefix, use ="Result: "&UPPER(A1). The ampersand (&) joins text together.

Common Mistakes

  • Forgetting the equals sign. If you type UPPER(A1) without the leading =, Google Sheets treats it as plain text, not a formula.
  • Using the wrong cell reference. Double-check that the cell reference in the formula (e.g., A1) matches the cell that actually contains your text. If you reference an empty cell, you’ll get an empty result.
  • Overwriting original data. If you type the formula directly into the cell that contains the text, you’ll lose the original. Always use a separate cell for the formula.
  • Expecting PROPER to handle all edge cases. The PROPER function capitalizes the first letter of every word, but it does not handle exceptions like “iPhone” or “McDonald”. It will turn them into “Iphone” and “Mcdonald”.
  • Dragging the fill handle incorrectly. If you drag the fill handle sideways instead of down, you’ll copy the formula to the wrong cells. Make sure you drag in the direction of your data.

Tips

  • Use absolute references for fixed cells. If you want to convert text from a single cell (like A1) but copy the formula across a row, use $A$1 instead of A1. This locks the reference so it doesn’t change when you copy.
  • Combine with TRIM. If your text has extra spaces, wrap it with TRIM first: =UPPER(TRIM(A1)). This removes leading, trailing, and double spaces.
  • Apply to a whole column quickly. Instead of dragging, you can double-click the fill handle (the small blue square) when you have data in the adjacent column. Sheets will auto-fill down to the last row with data.
  • Use keyboard shortcuts for editing. Press F2 to edit a cell, then use the arrow keys to move the cursor. This makes it easier to fix a formula without using the mouse.
  • Check the locale for PROPER. In some locales, PROPER may behave slightly differently with accented characters. Test with a sample if you work with non-English text.

Troubleshooting

  • The formula shows as text. If you see =UPPER(A1) as literal text instead of a result, the cell is formatted as “Plain text”. Go to Format > Number > Automatic to fix it.
  • You get a #NAME? error. This usually means you misspelled the function name. Check that you typed UPPER, LOWER, or PROPER correctly.
  • The result doesn’t update. If you change the original text and the converted text doesn’t update, check that the formula cell is not set to “Manual” calculation. Go to File > Settings > Calculation and select “On change and every minute” or “On change”.
  • You get a #VALUE! error. This happens when the cell reference is not text. For example, if A1 contains a number, UPPER(A1) will return an error. Convert the number to text first with =UPPER(TEXT(A1,"0")).
  • The fill handle doesn’t work. If dragging the fill handle doesn’t copy the formula, make sure the cell you are dragging from has a formula and that the cells you are dragging over are not part of a merged range.
  • PROPER capitalizes after apostrophes incorrectly. For example, “o’clock” becomes “O’Clock”. This is a known limitation. To fix it, you would need a more complex formula or a script, but for most uses it’s acceptable.

Frequently Asked Questions

Can I convert text case without using a formula?

No, Google Sheets does not have a built-in button for changing text case like some word processors. You must use the LOWER, UPPER, or PROPER functions. However, you can use the “Paste special > Values only” trick to replace the original text with the converted version once you’re done.

How do I convert text to sentence case (first letter capitalized, rest lowercase)?

There is no direct function for sentence case. You can combine functions: =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1)). This capitalizes the first character and lowercases the rest.

Will these functions work on numbers or dates?

No, they only work on text. If you apply them to a number, you’ll get a #VALUE! error. You can convert a number to text first using the TEXT function, but the result will be a text string, not a number.

Can I use these functions in Google Sheets on mobile?

Yes, the functions work the same way in the Google Sheets mobile app. Tap on a cell, type the formula, and press the checkmark to confirm.

How do I convert a whole column at once?

Type the formula in the first row of an empty column, then click the small blue square at the bottom-right of the cell and drag it down to the last row of your data. Or double-click the square to auto-fill.

What if I want to convert text but keep the original?

The formulas always keep the original cell unchanged. The converted text appears in the cell where you typed the formula. You can also copy the result and paste as values to replace the original, but that’s optional.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →