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?
------------------------
Watch video Excel - capital first letter | First letter capital formula | Change first letter to uppercase. online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 21 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,341 once and liked it 40 people.