how to convert capital letters to small letters in excel with first letter capital

To convert text in Excel so that the first letter is capitalized and the rest of the letters are lowercase, you can use this formula:

=REPLACE(LOWER(A2),1,1,UPPER(LEFT(A2,1)))

Here is how it works:

• LOWER(A2) converts all letters in the cell A2 to lowercase.
• UPPER(LEFT(A2,1)) converts the first letter of the cell A2 to uppercase.
• REPLACE replaces the first letter in the lowercase text with the uppercase letter.

This results in text that has a capital first letter and the rest in lowercase. If you want to capitalize only the first letter but leave the rest of the text unchanged (not forcing lowercase), you can use this formula:

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

Additionally, if you want the first letter of each word to be capitalized (title case), use the built-in PROPER function:

=PROPER(A2)

After entering any of these formulas in a helper column, you can copy the formula down the cells, and then copy-paste the results as values if you want to replace the original data. These methods ensure your text is formatted with the first letter capitalized and the rest in lowercase or unchanged, as needed.