Let’s say you have a list of text values, and you want to capitalize the first letter for each text. This thing can be easily done using a simple formula. And in this tutorial, we will learn to write this formula to capitalize the first letter of a word.
PROPER Function to Capitalize First Letter
In the following example, you have a list of names, and all these names are in lower letters. Now you need to convert the first letter into capital.
Use the following steps to capitalize the first letter.
- Type equal in cell B2.
- Enter the TEXT function and type the starting parentheses.
- Refer to cell A2 where you have text for which you capitalize the first letter.
- In the end, enter closing parentheses and hit enter to the result.
Only Capitalize the First Letter of the First Word
Now let’s take another situation where you only need to capitalize only the first letter of the first word and not the rest of the words. You can use the following formula for that.
=UPPER(LEFT(A2,1))&LOWER(RIGHT(A2,LEN(A2)-1))
To understand this formula, we need to break it into two parts.
The first part of the formula uses the UPPER and LEFT function that extracts the first letter from the text and converts it into the capital letter.
And the second part of the formula uses RIGHT, LOWER, and LEFT functions. These functions take the rest of the part of the text and convert that part into a lower letter text.
But if you want to capitalize the first letter and want to leave the rest of the part as it was, you can amend the above formula. See the following.
=UPPER(LEFT(A2,1))&RIGHT(A2,LEN(A2)-1)This formula will not make any changes to the text other than the first letter of the first word.