PROPER is a handy function within Excel which allows you to neaten up data sets by capitalising the first letter of a word and converting the following letters to lowercase. The formula for this is =PROPER(cell to be neatened), e.g., in the example below, we use =PROPER(A6) to show this function.