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.
Hello everyone, welcome to Excel 10 Tutorial. If you are new to me and this channel, I'm your trainer Kazi, and in this channel, I create tutorials on Microsoft excel every day. SO, make sure you hit that subscribe button bit.ly/2GOqj7k and Let's get started.
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.
In Column A, I have a list of sentences in different cases. Some of them are in Uppercase, some of them are in lowercase, and Some are in mixed cases. Usually, we write a formula in Column B, and we convert Column A in a way that only the first letter of a sentence is capital and rest will be in lowercase. Like I showed in a previous video, check that here: • How To Capitalize Only...
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.
So, click on the developer tab here. If you don't find the developer tab here, check out this video: • How to add developer t... it will show you how you can add the developer tab on the ribbon in excel. Now click on visual basic; it is called Visual Basic for Application. It is a programming language especially for Excel and other Office applications.
If you want to understand VBA Programming, please check out our VBA Course Here: bit.ly/excelvbacourse
Now write the code in the Visual Basic Editor (VBA)
Please subscribe and here goes the code: / 37910736
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
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
27 июл 2024