Excel - capital first letter | First letter capital formula | Change first letter to uppercase.
Download the featured file here: https://www.bluepecantraining.com/wp-...
Formula in video:
=UPPER(LEFT(D2))&LOWER(MID(D2,2,LEN(D2)))
In this video I demonstrate how to change the first letter in a cell to uppercase and the rest of the letters to lowercase. This can be achieved with or without formula and I demonstrate both methods.
This video will answer the following queries:
How to make first letter capital in excel shortcut keys?
How to change first letter to uppercase in Excel?
How to capitalize first letter in word?
What is the Excel formula for first letter capital?
------------------------
