PROPER Function – Convert Text – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the PROPER Function in Excel to convert text to proper case.

Proper Main Function

What Is the PROPER Function?

The Excel PROPER Function takes a given string as an input, and then returns that string with the first letter of each word in upper case, but every other letter in lower case.

How to Use the PROPER Function

You can use the PROPER function like this:

=PROPER(“bruce springsteen”)

First Proper

PROPER is useful when you have a column of data with inconsistent formatting.

For example, imagine you have a spreadsheet of musical artists, but the names haven’t been entered correctly. Some are upper case, some are lower, others are a mix of upper and lower… it’s a mess. You can use PROPER to fix this, as shown here:


How to Use PROPER

PROPER Impacts Every Word

Note that PROPER will affect every word in the text string. Depending on the data you have, this may or may not be desirable, for example:

PROPER Affects Every Word

How PROPER Handles Punctuation and Numbers

The Excel PROPER Function does not change numbers, punctuation, or special characters. However, it does treat them as spaces. That means PROPER will capitalize any letter that directly follows a number or a punctuation mark.

Check out these examples below:

How PROPER Handles Punctuation

Keeping State Codes Capitalized

If you only want to use PROPER on a portion of the text, and keep the rest in either upper or lower case, this can be tricky to do with formulas alone. However, if your data follows the same structure in every cell, you can often find away.

For example, if a column contains city names and state codes, and the state code is always the final two characters of the cell, we can format this by using PROPER and UPPER.

See the examples below:


State Codes

The formula uses PROPER, LEFT, and LEN to take the string in column A, trim off the last two characters, and pass the result to the PROPER function. Then, it takes the final two characters of the cell, applies UPPER to them, which converts them to upper case.

You can see the results in column E. Note that this formula will only work where the data is in exactly the same format.

PROPER in Google Sheets

The PROPER Function works exactly the same in Google Sheets as in Excel:

Proper G Function

PROPER Examples in VBA

You can also use the PROPER function in VBA. Type:


AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions