Launch Excel and create a new workbook. Click the workbook's "A1" cell and press "Ctrl-V" to paste your text into that cell. Click the "Data" button in the menu bar, then then click "Text to Columns." ...

Click on the row header for Row 1 of your spreadsheet. Click on the "Home" tab in the Excel ribbon. In the Font group, click on the "B" to make the headers you'll set in this row appear in bold text.

The first part of the formula is =UPPER(LEFT(T3,1)). It capitalizes the first letter of the first word in the sentence. The LEFT function instructs Excel to go to the far left of the text string; “T3” ...

To follow along with this brisk walkthrough, you can download the Excel spreadsheet created for this demonstration. This walkthrough and the accompanying video (available at the bottom of this article ...