Capitalize First Letter

HomeExcel FormulasCapitalize First Letter

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.

capitalize-first-letter

Use the following steps to capitalize the first letter.

  1. Type equal in cell B2.
  2. Enter the TEXT function and type the starting parentheses.
  3. Refer to cell A2 where you have text for which you capitalize the first letter.
  4. In the end, enter closing parentheses and hit enter to the result.
proper-function

Only Capitalize 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 for the rest of the words. You can use the following formula for that.

=UPPER(LEFT(A2,1))&LOWER(RIGHT(A2,LEN(A2)-1))

capitalize-only-first-letter

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.

upper-function

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.

lower-function

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.