How to capitalize first letter in excel
By
SpreadCheaters
Page last updated:
18/11/2022 |
Next review date:
18/11/2024
You can watch a video tutorial here.
Capitalization is very straightforward in Excel. Since we want to capitalize only the first letter, we will use the PROPER command.
Step 1 – Click on an empty cell
Click on an empty cell
Step 2 – Type in PROPER followed by the selected cell you want to capitalize
The PROPER command will automatically capitalize the first letter and turn the rest into lowercase.
Step 3 – Press Enter
Pressing Enter will return the output of the formula.
