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!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More