How to make first letter capital in Excel
Excel offers a very interesting way to make the first letter capital. We can cater to this problem statement by using the “=PROPER()” formula. We can perform the below mentioned way to make the first letter capital in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a text
– Open the desired Excel workbook which contains a text in lowercase in a cell
Step 2 – Formula applied
– Now type the formula “=PROPER(“ and give the reference of the cell where the text is present, and hit Enter.
Step 3 – Proper case generated
– We can see that the first letter has been made capital.