DEV4 Blog

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.

Published on 07 Apr 2021 by Joanna Hepburn

Add new comment...