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

In this video we discuss how to capitalize the first letter of text in a cell in excel. We go through 2 examples, cells with a single word and cells with multiple words

Transcript/notes
In this video we are going to cover how to capitalize only the first letter of text in a cell, going through 2 examples, cells with a single word, and cells with multiple words, starting with a single word.

To quickly capitalize the first letters of text in a cell in excel, such as in cell A2, we left click on an answer cell, in this case cell B2, so it is highlighted. Next, type in an equals sign, then type in pro. From here, in the drop down box, left double click on proper. Next, left click on the cell we want to apply the function to, in this case cell A3. Then, type in a closed parenthesis to close off the function, and then hit the enter key, and it has been done.

Now, I’m going to left click on cell B2, and use the fill handle for the other words in this list. And you can see that this function capitalizes the first letter of each word in the cell, such as with microwave oven.

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.

Now for only capitalizing the first word in a cell, and we are going to have to use multiple functions to do this, and I will explain the entire function after we have it typed in.

Left click on the answer cell, here, cell G2. 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 F2, 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 F2, 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.
As before, if you delete the data in column F, as you see here, it will also remove the data from column G, because it is referencing the data in column F. To avoid this, you can copy the data from column G, then right click in column F and go down and left click on paste special. Then in the pop up box, left click on values, then left click on ok. Now you can delete column G, and all of your text is cleaned up and neat.
=REPLACE(LOWER(F2),1,1,UPPER(LEFT(F2,1)))

Chapters/Timestamps
0:00 Intro
0:14 Single word cells - how to capitalize first letter
0:50 Copy and paste corrected cells
1:30 Multiple word cells - how to capitalize only the first letter of the cell
2:54 Copy and paste corrected cells