TedJordan.Org - Logo
Capitalize the first letter of each work with the Proper function

Table of Contents

Share this article

Join our newsletter

Excel: how to capitalise the first letter of each word

Bring clarity to your Excel text elements: learn how to capitalise each word with the PROPER function.

Tired of capitalising each word one by one in Excel? Or maybe you realised you capitalised the wrong letters?

With the Excel PROPER function, capitalise the first letter of each word automatically!

Are you ready to learn how to use this time-saving-formula?

Writing the first letter of each word in upper case can create visual interest and bring clarity to your data. Instead of doing it manually, you can use an Excel function called PROPER.

The PROPER function capitalises the first letter of each word in a cell and keeps other letters in lower case. Its formula is =PROPER(text) with text being a cell or a range of cells containing a text. If you want to use the formula directly with a text enclose it with quotation marks: =PROPER(your text“)

For example, =PROPER(“eXcel”) will become “Excel” in MS Excel.

Capitalise the first letter of each word in Excel by entering =PROPER(text); check the example below to get familiar with automatic capitalisation.

In this example, let capitalise the first letter of each word in cells A29 to A32.

Enter =PROPER(A29:A32) and press Enter.

Now, all words in these cells start with a capital letter!

Now, you know how to write the first letter of each word as capital letter in Microsoft Excel.

Become an Excel Master: join our Online Training Course now!