How to Change Lowercase to Uppercase in Excel Without Formula

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Change Lowercase to Uppercase in Excel without Formula: 5 Methods

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 lowercase letters to uppercase 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 Change Lowercase to Uppercase with Formula in Excel


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: Change Case for Entire Column in Excel


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.


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: Change Upper Case to Lower Case in Excel


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.


Download Practice Book

Download the following Excel file for your practice.


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. Please, drop comments, suggestions, or queries if you have any in the comment section below. 


Related Articles


<< Go Back to Change Case | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hafizul Islam
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

2 Comments
  1. Hi

    Thank you for the good work. I was looking for a way to automatically convert any entry I enter in specific cells to upper case by just only entering the text and without choosing the Caps only fonts.

    Thank you,

    Mashal

    • Hi MASHAL,
      You can use use VBA macro to automatically convert any entry you enter in specific cells to upper case by just only entering the text. Just follow these steps:
      1. Press ALT + F11 to open the Visual Basic for Applications (VBA) editor.
      2. In the Project Explorer window, locate and double-click on the “ThisWorkbook” module for the desired workbook.
      3. In the appeared code window, paste the following code:

      Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
      Dim rng As Range
      Set rng = Sh.Range("A1:Z100") ' Replace with the desired range
      
      If Not Intersect(Target, rng) Is Nothing Then
      Application.EnableEvents = False
      On Error Resume Next
      Target.Value = UCase(Target.Value)
      Application.EnableEvents = True
      End If
      End Sub

      Replace “A1:Z100” with the range of cells you want to convert to uppercase.
      4. Close the VBA editor.

      Now, whenever you enter any text within the specified range, it will be automatically converted to uppercase without the need to manually run any macro. Adjust the range in the code as needed to match your desired cells.

      Regards
      Rafiul Hasan
      Team ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo