Change Excel Text to Lower Case (Table of Contents)
- Excel Lower Function
- Using VBA Command Button
- Using VBA Shortcut Key
- Flash Fill
- Only Lower Case
- Microsoft Word
Change Capital Letters to Lower Case in Excel
There are many methods using which you can change capital letter text to lower case in excel. In this guide, we will look at the top 6 methods to change capital letters to lower case in excel in detail.
#1 – Using Lower Function to change case in Excel
There is a built-in function in MS Excel for decapitalizing each character in a word, which is LOWER function.
Suppose, we have a list of some verbs in excel, we want to change the case of text to lowercase.
To change case to lower, we need to write the function in cell C2 as ‘=LOWER(A2)’. ‘=’ or ‘+’ sign is used to write the function, ‘LOWER’ is the function name and A2 is the cell reference for the text for which we want to change the case.
Press Enter and this function will convert all letters in a text string to lowercase.
One value is converted now. For other values, we can either press Ctrl+D after selecting all the cells with top cell or press Ctrl+C and Ctrl+V for copying and pasting the function. Or we can drag the formula in other cells to get the answer.
#2 – Using VBA Command Button
We can create a VBA command button in excel and assign the code to change the following text to lowercase in excel using the command button.
To do the same, the steps are:
Step 1: To create the command button, click on ‘Insert’ command in the ‘Controls’ group in ‘Developer tab‘. And select the ‘Command Button’.
Step 2: Click the worksheet location at which you want the command button to appear. We can resize the command button using the ALT button.
Step 3: Using the ‘Properties’ command, change the properties of the command button like caption, name, AutoSize, WordWrap, etc.
Step 4: Now to assign the code to the command button, click on ‘View Code’ command in the ‘Controls’ group in ‘Developer’ Make sure ‘Design Mode’ is activated.
Step 5: In the opened window, please select ‘ConvertToLowerCase’ from the drop-down list.
Step 6: Paste the following code in between the lines.
Dim Rng As Range Dim c As Range On Error Resume Next Set Rng = Selection For Each c In Rng c.Value = LCase(c.Value) Next c
Step 7: Exit the visual basic editor. Make sure the file is saved with .xlsm extension as we have a macro in our workbook.
Step 8: Deactivate ‘Design Mode’. Now after selecting the required cells, whenever we click on the command button, the values are converted to lowercase.
Select all the values from A2:A10 and click on the command button. The text will get changed to lowercase in excel.
#3 – Using VBA Shortcut key
This way is similar to the above one except for the fact that we do not need to create the command button here.
Step 1: Either open the Visual Basic editor from the ‘Developer’ tab or by using the excel shortcut key (Alt+ F11).
Step 2: Insert the module using Insert Menu -> Module Command.
Step 3: Paste the following code.
Sub LowerCaseConversion() Dim Rng As Range Dim c As Range On Error Resume Next Set Rng = Selection For Each c In Rng c.Value = LCase(c.Value) Next c End Sub
Step 4: Save the file using Ctrl+S. Exit the visual basic editor. Make sure the file is saved with .xlsm extension as we have a macro in our workbook.
Step 5: Now choose the ‘Macros’ in ‘Code’ group in the ‘Developer’ tab.
Step 6: Then click on ‘Options’ and assign the shortcut key to the Macro and we can write a description as well.
In our case, we have assigned Ctrl+Shift+L.
Step 7: Macro is ready to use. Now to change the values into lowercase, select the required cells and press Ctrl+Shift+L.
#4 – Using Flash Fill
If we establish a pattern by typing the same value in lowercase in the adjacent column, Excel’s Flash fill feature will fill in the rest for us based on the pattern we provide. Let us understand this with an example.
Suppose, we have the following data which we want to get in lowercase.
To do the same, we need to write the first value of the list in the lower case manually in the adjacent cell.
Come to the next cell in the same column and just press Ctrl+E.
Choose ‘Accept Suggestions’ from the box menu appeared.
That is it. We have all the values in the lower case now. Now we can copy the values, paste the same onto the original list, and delete the extra value from the right.
#5 – Enter Text in Lower Case Only
We can make a restriction in excel so that the user can enter text values in lowercase only.
To do this, the steps are:
- Select the cells which you want to restrict.
- Choose ‘Data Validation’ from the ‘Data Tools’ group from the ‘Data’ tab.
- Apply the settings explained in the figure below.
- Now whenever the user will enter the value in capital letters, MS Excel will stop and will show the following message.
#6 – Using Microsoft Word
In Microsoft word unlike Excel, we have a command named ‘Change Case’ in ‘Font’ group in the ‘Home’ tab.
Suppose, we have the following table of data in excel for which we want to change text case to ‘Lower’ Case.
To change the case, first, we will copy the data from MS Excel and paste it into MS Word. To do the same, the steps are:
Select the data from MS Excel. And press Ctrl+C to copy data from MS Excel.
Open the MS Word application and paste the table using the Ctrl+V shortcut key.
Select the table using the ‘Plus’ sign on the left-top side of the table.
Choose ‘Change Case’ command from the ‘Font’ group and select ‘lowercase’ from the list.
Now, the data table is converted to ‘Lower’. We can just copy the table after selecting the ‘Plus’ sign from the left top corner and paste it into Excel back.
We can delete the old table using the contextual menu, which we can get by right-clicking on the table.
Things to Remember about Lower Case in Excel
To convert the values into lower case, if we use the VBA code (Command button or Shortcut key). In that case, we need to save the file with .xlsm extension as we have macros in the workbook.
This has been a guide to Lower Case in Excel. Here we discuss the top 6 ways to change capital letters in excel to lower case including – Lower Function, VBA Code , Flash Fill , VBA shortcut keys etc along with examples. You can learn more about excel functions from the following articles –