• How to change text from all capital letters to proper case.


6th August 2017......

In this, our first blog, I am going to show you a helpful built in Excel function that changes all capital letters in a cell into proper case.

This is especially useful if you have been given for example a list of contacts to email or write to them but naturally don't want to address them all in capitals. If there was just a few you could change them by hand, but what if the list was over 200 contacts?

Fig 1 below shows an example of this with a small amount of names.

List of names to be changed to proper case

Fig 1 - A list of names all in capital letters.

Now, rather than changing each one manually, it's much easier to use a built in Excel function.

The function we are going to use is the PROPER function.

Select cell B4, type the equals sign and then type proper and an open bracket.

See figure 2 for example.

First step to applying the proper function to the list of names

Fig 2 - Selecting the cell you want to change using the PROPER function.

Place the mouse pointer over cell C4 and left click. Now press enter.

You should now see that the cell B4 contains the same name as in cell C4 but with only the first letter of the first name and surname in capital letters.

Now to make that stretch all the way down column C, you don't have to type it in for each cell. There are a couple of options available to you.

One way is to select cell B4 and then on the outer green border of the selected cell, there is a green square on the bottom right. Double click this and the function you just used will apply all the way down the data set.

The other way is to copy and paste the function all the way down, by right clicking on cell B4, and selecting Copy. Then select cell B5 with the left mouse button and drag down to B9. Release the left button and right click the mouse, and select Paste. The cells should now update with the applied formula.

Final output after applying the whole process of the proper function to the list of names

Fig 3 - The output after using the function on the whole data set.

This may only have been on 6 records, but you can see how this would save time when you have many records to change.

Look out for more handy hints and tips on our next blog when we look at the VLOOKUP function.