Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents, spreadsheets, and presentations online, in OneDrive.

How to capitalize first letter only or first letter of each word in Excel?

1. Microsoft Office: Word, Excel, PowerPoint & More Android latest 16.0.2 APK Download and Install. One app for documents, spreadsheets, presentations, PDFs.
2. On the Page Layout tab in Excel or the Design tab in Word, click Themes Save Current Theme. In the File name box, enter a name for the theme, and click Save. Note: The theme is saved as a.thmx file in the Document Themes folder on your local drive and is automatically added to the list of custom themes that appear when you click Themes.
3. Choose ‘Word’ as the output and convert your Excel to Word. While the desktop app does require a Pro subscription, we offer every user who requires offline processing a two-week free trial for you to test our product out, in its full capacity. If you prefer to convert Excel to Word online, this is not the case, and no account is needed.

Supposing you have a list of text strings which words are in all uppercase, lowercase or mixed with lowercase and uppercase, in this situation, you need to make the first letter of each word in the cell to be uppercase, and others are lowercase as following screenshot shown. Do you have any good ways to capitalize or uppercase the first letter of each word for multiple cells quickly and easily in Excel?

Capitalize first letter of each word or first letter only with Kutools for Excel

Capitalize first letter of each word within cell with formula and VBA code

To make the first letter of each word within a cell capitalize, you can use the Proper function or a simple VBA code. Please do with following steps:

Method1: Proper function:

1. Enter this formula: =PROPER(A2) into a blank cell next to your data, B2 for instance, see screenshot:

2. And then drag the fill handle down to the cells that you want to apply this formula, and you can see all the first letters of each word within the cell have been capitalized. See screenshot:

Method2: VBA code:

The following VBA code also can help you to uppercase all of the first letter of each word in a cell.

1. Please hold down ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Capitalize first letter of each word in a cell

3. Then press F5 key to execute this code, and select the data range that you want to use in the popped out dialog box, see screenshot:

4. And then click OK button, all the first letter of each word in the cells have become capitalized.

Capitalize the first letter only or the first letter of each word in text string cells

With the help of Kutools for Excel’s Change Case utility, you can quickly change the text strings to upper case, lower case, proper case, sentence case and so on. Click to download Kutools for Excel!

Capitalize first letter only within cell with formula

Sometimes, you just want to uppercase the first letter only and lowercase others in the cell, are you suffered with this problem in Excel? In fact, here is a formula may do you a favor to solve this task.

Word Excel Mail Merge

1. Type this formula into a blank cell besides your data, =UPPER(LEFT(A2,1))&LOWER(RIGHT(A2,LEN(A2)-1)), see screenshot:

2. Then drag the fill handle to the range of cells which you want to contain this formula, and only the first letter of the cells has become uppercase. See screenshot: Helio g60.

Word Excel Software

Capitalize first letter of each word or first letter only with Kutools for Excel

If you have Kutools for Excel, with its Change Case feature, you can quickly capitalize both first letter of each word and first letter only in a cell.

After installing Kutools for Excel, please do as follows:

Word Excel 2

1. Select the data range that you want to use.

2. Click Kutools > Text > Change Case, see screenshot:

3. In the Change Case dialog box, if you select Proper Case, the first letter of each word will be capitalized, see screenshot:

If you choose Sentence case, only the first letter of the text strings are capitalized as following screenshot shown:

Demo: Capitalize first letter of each word or first letter only with Kutools for Excel

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Word Excel Templates

Word And Excel For Free