Free Excel Macro : Convert to Proper Case

Download now!

Download free Excel Macro : Convert To Proper Case

Macros are one of the most powerful features in Excel. They are small programs that can automate tasks and save you a lot of time.

If you are not familiar with macros, they can seem a bit daunting. But once you learn how to use them, you will wonder how you ever managed without them!

In this article, we will show you how to use the Macro "Convert To Proper Case" in Excel. We will also provide some examples of how macros can be used to automate tasks.

How to use Macros in Excel?

Macros are written in a programming language called Visual Basic for Applications (VBA). VBA is a simple language that is easy to learn.

You do not need to be a programmer to use macros. However, if you are familiar with programming, you can use VBA to create more complex macros.

There are two ways to use macros in Excel:
    1. Use a macro that is already written.
     2. Write your own macro.

For both methods check out those articles to know how to use macros in Excel: https://www.macrosinexcel.com/introduction-to-macros-in-excel/
https://www.macrosinexcel.com/create-write-macros-in-excel/
https://www.macrosinexcel.com/macros-in-excel-with-examples/

To create a macro in Excel, open the Visual Basic Editor (VBE) by pressing Alt+F11 on your keyboard.

In the VBE, select Insert > Module. This will insert a new blank module into the VBE.

In the new module, paste the code below.

For example, the following code will create a macro that will Convert to Proper Case:

Sub convertProperCase()
Dim Rng As Range
For Each Rng In Selection
If WorksheetFunction.IsText(Rng) Then
Rng.Value = WorksheetFunction.Proper(Rng.Value)
End If
Next
End Sub

To run the macro, press the Run button in the toolbar (or press F5 on your keyboard).

About Convert To Proper Case Excel Macro

If you have ever had to convert a list of text strings to proper case, you know how time-consuming and frustrating it can be. Proper case means that the first letter of each word is capitalized, while all other letters are lowercase. Thankfully, there is a handy Excel macro that can do all the work for you. To use the Convert to Proper Case macro, simply enter your text strings into the left column. Then, click the "Convert" button and your strings will be instantly converted to proper case. It's that easy! This macro is a lifesaver for anyone who needs to convert a list of text strings to proper case. Give it a try and see for yourself how easy and convenient