How to Capitalise Names formula Excel
Capitalize the first letter in each word
How to tidy up a list of names in Excel with just one formula
I’ve got a list of messy names which need to be converted to it’s proper format
Here is how we can quickly tidy up the names
Type =proper and click on the messy name and hit enter
Drag the formula down and Excel will tidy up all of the names and our problem is solved
Use =proper for names or other types of text when you want each word to have the first letter capitalised!
Check out my video on screen or in the description on how you can make Excel Talk – or check out the other videos on my channel!