Go Back

Put Names in Proper Case

Excel allows us to put names in proper case using the PROPER function. This step by step tutorial will assist all levels of Excel users in putting names in proper case.

Figure 1. The final result of the PROPER function

Syntax of the PROPER Formula

=PROPER(text)

The parameter of the PROPER function is:

  • text – a text which we want to convert to proper case.

The function converts the first letter of every word in a cell into upper case.

Setting up Our Data for the Examples

Our table consists of 2 columns: “Name” (column B) and “Name in Proper Case” (column C). In column C, we want to get names from column B in proper case.

Figure 2. Data that we will use in the PROPER function example

Convert Names to Proper Case Using the PROPER function

In the cell C3, we want to get the name from B3 in proper case.

The formula looks like:

=PROPER(B3)

The parameter text is the cell B3 (“mike t. jefferson”).

To apply the PROPER function, we need to follow these steps:

  • Select cell C3 and click on it
  • Insert the formula: =PROPER(B3)
  • Press enter
  • Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

Figure 3. Using the PROPER function to convert names to proper case

As you can see the name from B3 is converted to proper case, so the result in the cell C3 is “Mike T. Jefferson”.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
I need to separate first and last names on my spreadsheet. Then some of the names are all upper case and I want to make them upper and lower case
An Excelchat Expert solved this problem in 29 mins!
I am trying to put multiple addresses and names from one spreadsheet into a specific cell of another one
An Excelchat Expert solved this problem in 11 mins!
I am trying to change all the names to lower and upper case
An Excelchat Expert solved this problem in 18 mins!
Here are some problems that our users have asked and received explanations on
Looking for a forumula that will take out the middle names just leaving Title and Surname that will also change from Upper Case to PROPER.
Solved by G. J. in 20 mins
Ok, I will try this. I have a code that makes sure the member names on my spreadsheet are in the proper case in Columns D and E respectively. The second code is supposed to find the word "Completed" (Column L) from my drop down menu and put a static date in Column M. It was working and then it just stopped. I am so frustrated at this point I think I need help?
Solved by Z. J. in 22 mins
Ive got a bunch of names and id like to put that into a pie graph?
Solved by S. W. in 28 mins

Leave a Comment

avatar