Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles capitalize How to Capitalize Letters in Google Sheets and Excel

How to Capitalize Letters in Google Sheets and Excel

To capitalize all letters in Excel or Google Sheets we can use the UPPER function or Word as a faster solution. If we want to capitalize the first letter of each word in the cell we can use the PROPER function. Word is the fastest solution to get sentence case in Excel or Google Sheets without using formulas.

Capitalize all letters in Excel with UPPER Function

If we want to have all caps letters in excel cell, we should use the UPPER function. This function converts all characters in the text to the upper case. Formula syntax is simple, we just have to select the cell where we want to capitalize the letters.

Figure 1. Capitalize all letters in Excel

  • Select the cell D3 and write the formula: =UPPER(B3)
  • Press enter
  • Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

All CAPS in Google Sheets

Logic is the same if we want to capitalize all letters in Google Sheets. Select the cell D3 and insert the formula: =UPPER(B3). Copy the formula down by dragging icon “+” of the cell, as explained in the example above.

Figure 2. How to capitalize all letters in Google Sheets

Capitalize First Letter in Excel with the PROPER Function

To capitalize each word in Excel we can use the PROPER function. For each word in the cell, this function converts the first letter to the upper case.

Figure 3. Capitalize first letter in Excel for each word

  • Select the cell E3 and write the formula: =PROPER(B3)
  • Press enter
  • Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

How to Capitalize First Letter in Google Sheets

The PROPER function works exactly the same as in the Excel example. Insert PROPER formula in the cell E3: =PROPER(B3) and copy the formula down by dragging the icon “+” in the bottom-right of the cell.

Figure 4. Capitalize the first letter in Google Sheets for each word

How to Get Sentence Case in Excel and Google Sheets

Without using a complex formula we can easily get Excel sentence case with Word help. Select the cell range for which we want to create sentence case and copy data with Ctrl+C.

Figure 5. Capitalize the first letter of the cell with Word

Paste the data with Ctrl+V to the Word document:

Figure 6. Use Word to get sentence case in Excel and Google Sheets

Select the entire text and choose Sentence case in the Change Case icon in the Word.

Figure 7. Change Case Word option

As a result, there is the capital first letter in each row:

Figure 8. Capitalize first letter in Excel and Google Sheets using Word

Now we can select all the data from Word file and copy it to Excel file (or Google Sheets). If we don’t want to use formulas or to insert helper columns, Word is the easiest solution to change letters in uppercase, lowercase, sentence case or to capitalize each word.   

Figure 9. Get sentence case in Excel or Google Sheets using Word

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc