How to Capitalize First Letter of a String in Excel?

0
1271

To uppercase only the first letter in a cell in Excel, you can use the following formula:

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

For a sample string: “THIS is A SaMPLE StRIng.”

The result will be:

"This is a sample string."

A visual is below for your reference:

excel capitalize first letter

If you want to instead capitalize the first letter of each word in a cell, or uppercase/lowercase all characters in a cell, Excel already has some prebuilt formulas to do so.

For more questions about capitalization, use our free title capitalization tool.


Capitalize My Title is a dynamic title capitalization tool used to make sure your titles or headlines use proper capitalization rules according to various style guides include APA, AP, MLA, and Chicago. It also counts your words and checks for grammar issues.

LEAVE A REPLY

Please enter your comment!
Please enter your name here