Capitalize Only the First Letter of a Sentence Instantly in Microsoft Excel

I'll show you precisely what you need to do to Capitalize Only the First Letter of a Sentence instantly in Microsoft Excel. I'll be doing it on Excel 2019 version, and you can follow this procedure on any version from Excel 2010 to Onward.

How to convert only the first letter to capital letter & the rest in Small letter in a sentence? This is not something you can do with Proper() function. Proper function capitalizes the first letter of each word, but we need to capitalize only the first letter of a sentence, not each word.

If we use formula, then we need a helper column like Column B, and if you want to remove that column, you'll have to Format the whole helper column into text and then remove the original column. That's disturbing when you are working on a formatted worksheet. So, in this tutorial, we will convert all the sentences in Column A, and the result will also be in Column A. So, we can change the content of Column A, and you don't need another column to show the result.

Now write the code in the Visual Basic Editor (VBA)

So, our code is ready, and let's close the VBE. Now, let's run the macro. Click on the Macros and click on the run button. Done, you've changed all the sentences in a way that only the first letter of these sentences is capital, and the rest of them are in small letter. Now in the future, I'll show you how you can create a button and when you press that button, you'll be able to Capitalize Only the First Letter of a Sentence in Excel.

#Excel #Uppercase
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[godwinuche]

You are the best tutor in excel on YouTube. You teach us like kids I love that

[godwinuche]

I’m always happy whenever I see clearly what you are showing on the screen it makes learning more easier. Please send the code to my mail . Many thanks

[jogicadsolution]

THANKS ..

IF TWO SENTNECE IN ONE CELL THAN HOW TO DO...?