Capitalize First Letter of Every Word in a Cell - PROPER Function

Add to Favorites
Author:

In Excel you can use a function to capitalize the first letter of every word in a cell.  This allows you to prepare your data in Excel quickly and easily.

To do this, we use the PROPER function.

Syntax

=PROPER(text)

Argument

Description

Text

This is the text for which you want every first letter to be capitalized.  This can be a reference to a cell or you can input the text directly in the function so long as you surround it with double quotation marks like this: "your text".

PROPER Function Example

Here we have sample text:

Put the proper function in cell B1 and reference cell A1 for the text argument:

Hit enter and here's the result:

I did this on one cell, but it will really save you a lot of time if you have a large list of data and you need each first letter to be capitalized.  Then, you just enter it for the first cell and copy the function down by double-clicking the quick-fill handle, which is located in the bottom right of any cell that you have selected.

PROPER Function with Hard-coded Text

You will probably never do this but you can.

The result:

Make the New Capitalized Text Actual Text Instead of a Function

Even though cell B1 and B2 look like text, they are actually cells with a function, the PROPER function, inside of them.

To make them actual text, we need copy them and then paste-special their values.

First, select the desired cells:

Hit Ctrl + C:

Hit Alt + E + S + V and then Enter:

Now, both cells B1 and B2 are filled with the text that you see instead of a function.


Excel Function: PROPER()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorial Details
Excel Function: PROPER()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course