How to make first letter capital in excel without formula

Turning text into capital letters in Excel is a handy skill to have. Whether you’re organizing data, creating a title, or simply ensuring consistency, capitalizing text can help your work look polished and professional.

But how do you do it quickly and efficiently? It’s pretty simple, actually. After reading this paragraph, you should be able to capitalize text in Excel with ease.

Step by Step Tutorial on How to Capitalize in Excel

Before we dive into the steps, it’s important to know that we’ll be using a function in Excel called UPPER.

How to capitalize all letters in word

This function converts all letters in a text string to uppercase.

Step 1: Select the Cell or Range of Cells

Click on the cell where you want the capitalized text to appear.

In this step, you’re choosing where you want the change to happen.

If you’re capitalizing a single cell, just click on it. For multiple cells, click and drag to select them all.

Step 2: Type the UPPER Function

Type =UPPER(A1) into the selected cell, replacing A1 with the cell you want to capitalize.

Here’s where the magic happens.

The UPPER function is what tells Excel

how to capitalise first letter in excel

how to capitalize text in excel formula