Excel: Capitalize First Letter of Each Word in a Cell

In this video I demonstrate how to capitalise the first letter of each word in a cell. This might be useful where you have first name, last name in a cell and you need to correct case.

The first method I demonstrate uses Flash Fill - a feature that appears in more recent versions of Excel. The second method I demonstrate uses the PROPER function which is available in all versions of Excel.

This video will be useful if you have the following queries:
How do you capitalize first letter?
What's it called when you capitalize the first letter of each word?
How do you capitalize words in Excel?
Excel uppercase first letter of first word.
How to change first letter to uppercase in Excel?
------------------------