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 of the 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.

## More Formulas

- How to Change Column to Row (and Vice Versa) in Excel
- How to Change to Sentence Case in Excel
- How to Create a Horizontal Filter in Excel
- How to Create a Star Rating Template in Excel
- How to Get File Name in Excel
- How to Get Sheet Name in Excel
- How to Quickly Generate Random Letters in Excel
- Randomize a List (Random Sort) in Excel