In Excel there is a function that can be used to make every word in a sentence start with a capital letter. It can be useful if we want some consistency in our data.
If we want every word to start with a capital letter, enter the following formula in B2:
=PROPER(A2)
The result looks like this:
Excel tutorials 
Leave a comment