Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

Date:2021-7-19 Author:Sandra

We have mentioned methods of how to quickly change the case of a Word in a previous Microsoft Word tutorial. But that doesn’t work in Excel.

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

Let’s take the words in the green cells as an example, capitalize them in the blue cell.

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

Now, we type PROPER() in cell E1 and press Enter key. Then hit Ok.

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

After you hit Ok, click on cell A1. A blue box will appear, and press Enter key.

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

You’ll notice that the word with a capital letter appears in cell E1.

When the cursor becomes a black solid plus in the lower right corner of cell E1, click and fill down.

How To Capitalize First Letter In Microsoft Excel-Simple Tutorial
How To Capitalize First Letter In Microsoft Excel-Simple Tutorial
How To Capitalize First Letter In Microsoft Excel-Simple Tutorial

That’s the end of the tutorial, I hope it’s helpful!

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *