First, select the cell where you want to insert the formula to correct the names.Let’s demonstrate the procedure to use it to capitalize the first letter of each word.
It is possible to use it to capitalize each word in a string. The function in Excel converts user input text to the proper case. The PROPER function transforms the initial character to the upper case and the other characters to the lowercase. Capitalize First Letter of Each Word Using PROPER Function
#Ms word initial caps how to
Read More: How to Capitalize Each Word in Excel (7 Ways)Ģ. This will automatically capitalize all the first letters for each word. You will be able to see your desired result. Finally, to use the Flash Fill option, press Ctrl + E.Secondly, to confirm the entry press Ctrl + Enter.Firstly, select the cells and type the text with capitalized initial characters in a cell adjacent to the cell holding the content So, we select cell C5, and type the corrected name.To use the Flash Fill to capitalize the first letter of each word, let’s follow the quick steps below. Based on the initial item, it anticipates the rest of the data. Use Flash Fill Option to Capitalize First Letter of Each Wordįlash Fill allows us to enter data more quickly and accurately. Now, we will correct the name in column C.ġ. To capitalize the first letter of each word we are going to use the following dataset which contains some employee names in column B but in the wrong way. But still while working with lots of data, we may mistakenly insert data incorrectly. And it could be done easily, just use the keyboard to manually alter the contents of the cells. Users of Excel may need to change the case of text in their spreadsheets on occasion. 4 Ways to Capitalize First Letter of Each Word in Excel