Скачать или смотреть How To Capitalize Only The First Letter Of The First Word In A Text String In A Cell In Excel

In this video we discuss how to capitalize only the first letter of the first word in a text string in a cell in excel. We go through a detailed example step by step.

Transcript/notes
To capitalize only the first letter of a multiple word text string in a cell, we are going to have to use multiple functions nestled within one another. Here is the entire finished formula, that we are going to go through now.

To start, left click on the answer cell, here, cell B2. Next, type in an equals sign, then type in rep, and a box appears, in the box left double click on REPLACE. Now, we type in lo, and a box appears, in the box left double click on LOWER. Next, we left click on the reference cell, cell A2, then type in a closed parenthesis, then type in a comma. Now, type in a 1, then a comma, then type in another 1, followed by another comma.

Next type in the letters upp, and in the pop up box, left double click on UPPER. Now, type in lef, and in the pop up left double click on LEFT. From here, left click on the reference cell, cell A2, then type in a 1. Next, to finish the formula, type in 3 closed parentheses. And now hit the enter key, and we have our answer, with just the first letter of the first word capitalized.
And I will use the fill handle to fill in the rest of the column.

One quick note, if you delete the data in column A, as you see here, it will also remove the data from column B, because it is referencing the data in column A. To avoid this, you can copy the data from column B, then right click in column A and go down and left click on paste values. Now you can delete column B, and all of your text is cleaned up and neat.

Chapters/Timestamps
0:00 How to capitalize only the first letter of the first word in a multiple word text string in excel
0:10 Entire finished formula written on the screen
1:38 Copy and paste values to reference column