How to Change Lowercase to Uppercase in Excel Without Formula

If you are facing problems in changing lowercase to uppercase or vice versa in Excel without formula, and you want to overcome the problems, then you are in a right place. In this tutorial, you will learn 5 effective methods to change cases without formula in Excel with proper illustrations.


Download Practice Book

Download the following Excel file for your practice.


5 Methods to Change Lowercase to Uppercase in Excel without Formula

Here, we have a data set containing two columns. Our goal is to change lowercase texts on the left column to uppercase on the right blank column. 

Some Names with Lowercase Format


1. Use the Flash Fill Feature

Flash Fill senses the pattern in your text and fills your data in this way. It identifies the cell value pattern and repeats the order for the rest of the cells. 

To change the uppercase letters to lowercase with the Flash Fill feature, follow the steps below.

Steps:

  • First of all, type the first lowercase text “chris” (which is in Cell B5) in Cell C5 in uppercase format, i.e. “CHRIS“. Then press Enter.
  • Press Alt+E to activate the Flash Fill.
  • Now, start to type E (for EVANS).

You see, MS Excel suggests the rest. Not only that, but Flash Fill also suggests the rest of the names if they are to be typed in the same manner.

  • Just accept the suggestion by pressing Enter.

Use Flash Fill to Change Lowercase to Uppercase in Excel

Read More: How to Capitalize All Letters Without Formula in Excel (4 Quick Methods)


2. Use Excel Caps Fonts

When you always want a text in uppercase and you don’t want to worry about how the text will be typed, you can use a font that has no lowercase style of the letters. The following fonts are always in the uppercase version of the letters. 

  • Stencil
  • Engravers
  • Copperplate Gothic
  • Felix Titling
  • Algerian

Steps:

  • Under the Home tab, select a font of the above list from the font dropdown list or type the font name on the box. Here, I have chosen Copperplate Gothic. 
  • Now type anything; here, the names, not worrying about the case anymore (it will be written in uppercase automatically now).

Use Excel Caps Fonts to Convert Lowercase to Uppercase

Note:

The output is always in an uppercase style whether you type your text in lowercase, mixed-case, or uppercase.

Read More: How to Stop Auto Capitalization in Excel (with Quick Steps)


3. Change Lowercase to Uppercase in Excel with the Help of Microsoft Word

If you don’t feel comfortable using formulas in Excel, you can apply a system for converting text cases in MS word. Just follow the steps below.

Steps:

  • Copy the range of cells i.e. B5:B10 that you want to change cases in Excel. 
  • Open an MS Word document.
  • Paste the copied cells in it.
  • Select the texts that you want to change cases.
  • Under the Home tab, click on the Change Case icon. Pick UPPERCASE options from the list.

Change Lowercase to Uppercase in Excel Using Microsoft Word

  • Now copy the text from the word table.
  • Right-click on Cell C5.
  • Select the paste option as in the following image.

Here is the result.

Read More: How to Change First Letter to Uppercase in Excel (6 Handy Methods)


Similar Readings


4. Use an Excel VBA Code to Convert Letters to Uppercase

If you feel comfortable using the VBA codes in Excel, then copy the following code and paste it into the code module, and finally Run the code to get the result. 

Steps:

  • Select the column in which you want to change the case.

  • Press Alt+F11 and a VBA module will open.

Use Excel VBA to Convert Lowercase Letters to Uppercase

  • Paste the following code in the module.
Sub Upper_case()
For Each Cell In Selection
If Not Cell.HasFormula Then
Cell.Value = UCase(Cell.Value)
End If
Next Cell
End Sub
  • Then press Run Sub/UserForm, or just press F5.

Here is the result.

Notes: To apply Lowercase, insert the following code into the Module window.

Sub Lower_case()
For Each Cell In Selection
If Not Cell.HasFormula Then
Cell.Value = LCase(Cell.Value)
End If
Next Cell
End Sub

Again to apply Propercase, insert the following code into the Module window.

Sub Proper_case()
For Each Cell In Selection
If Not Cell.HasFormula Then
Cell.Value = _
Application _
.WorksheetFunction _
.Proper(Cell.Value)
End If
Next Cell
End Sub

Read More: How to Change Lowercase to Uppercase with Formula in Excel (3 Ways)


5. Use the Power Query Tool to Change Lowercase to Uppercase

Power query is a significant tool for data transformation. By applying Power Query, we can convert the case into lowercase, uppercase, and propercase styles. Follow the steps below.

Steps:

  • Select any cell in the dataset.
  • Go to the Data tab> From Table/Range.

A pop-up will appear.

  • Mark My table has headers option.
  • Check the data range as shown in the screenshot below.
  • Press OK.

Change Lowercase to Uppercase Using Excel Power Query Tool

  • A Power Query Editor window will pop up.
  • Ensure the column is selected, then go to Add Column> Format> UPPERCASE. A new UPPERCASE column will be created beside the previous lowercase column.

Change Lowercase to Uppercase Using Excel Power Query Tool

  • Now go to the File tab> Close & Load.

  • The following table will be created in your Excel file in an additional worksheet.

Read More: How to Format Text to Capitalize First Letter in Excel (10 Ways)


Conclusion

In this tutorial, I have discussed 5 easy methods of how to change lowercase to uppercase in excel without formulas. I hope you found this tutorial helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below. 


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo