Home / Beginner / How to use the Proper function to re-format Names

How to use the Proper function to re-format Names

The ExcelHelpDesk team received the following request for help….

…..”I have been given an Excel file with 503 contacts, their names, addresses, phone numbers, emails, etc. In order for the sheet to upload into another program that we have, it is necessary for me to parse apart much of the information. In addition, all of the information is in capital letters and I have been asked to only capitalize the first letter of each proper name. This means that I am in the process of retyping 503 lines of information. Is there any quick way to change case in Excel? Thank you so much for your help”……

Excel’s built-in functions can be used to solve this problem and save you many hours to tedious re-typing. The function we will use to solve this problem is the Proper function. Here is the help information for the Proper function.

Proper Function

For this post we will assume that the contact details have been parsed into separate columns like the data below…

Step 1

Now in cell D2 type =PROPER(A2) and press enter. The cell will now contain a properly formatted Name for the contact.

Step 2

Drag and Copy that formula down to the cell D5 and each of the Contact names will be re-formatted

Step 3

Finally to format the address for each of the contacts Drag and Copy the formula across to cell E5. Now the formatting will be completed for each of those cells.

If you have a question on this post for the Excel Help Desk team or have something you would like to share on this topic then please leave a comment.

About Excel Help Desk

Check Also

Split Function

The Split function is a VBA function that is used for breaking strings into an array. The separation of string is identified by indicating a character or set of characters which are called delimiters. This function comes in handy, for example, when you have a list of whole names of people in a column of your worksheet and you want to split them in order to get the first and last names of each person.

2 comments

  1. I would like to get the total calculated amount of the following figures:

    Consumed Unit Slab Rate per unit (Banglaeshi Taka)
    654 0 – 75 3.33
    76 – 200 4.73
    201 – 300 4.83
    301 – 400 4.93
    401 – 600 7.98
    601 – above 9.38
    Please tell me what formula should be appropriate for this figure.
    Thanks