Excel Formula: Change Case of First Letter Only

If you want to change the case of the first letter of any cell text in an Excel sheet. Here is very simple formula. This excel formula will change the case of the first letter only. Other text after the first letter will remain the same. This formula will change the case of the first letter in cell C2.

=REPLACE(C2,1,1,UPPER(LEFT(C2,1)))

Comments
Loading...