HomeApplicationOffice information

How to convert uppercase to lowercase in Excel simple and fast

Unlike Microsoft Word, Microsoft Excel does not have the ability to change characters to convert from uppercase to lowercase. However, you can use the Lower function in Excel to do this easily and quickly. Let's practice with TipsMake.com with functions in Excel.

Method 1: Change uppercase to lowercase in Exel with the Lower function.

Step 1: In the adjacent cell D2, enter the formula = LOWER (B2). See screenshot:

How to convert uppercase to lowercase in Excel simple and fast Picture 1

Step 2: Press the Enter key and the formula has been applied to cell D2, then select cell D2, select the range of cells you want to apply this formula. And all uppercase text strings have been changed to lowercase. See screenshot.

How to convert uppercase to lowercase in Excel simple and fast Picture 2

Method 2: Use Unikey to convert uppercase to lowercase

Step 1: Highlight all the text you want to convert uppercase to lowercase by using the shortcut Ctr + A then right-click and select Copy or use Ctr + C on the keyboard.

How to convert uppercase to lowercase in Excel simple and fast Picture 3

Step 2: Right-click the Unikey icon on the toolbar and click on Tools . [Ctr + C] or press the keyboard shortcut Ctrl + Shift + F6.

How to convert uppercase to lowercase in Excel simple and fast Picture 4

Step 3: When the Unikey Toolkit window appears, check the 'Lowercase letters' box, then click 'Reverse code' as shown below.

Note: The source must be for TCVN3 (ABC) and Unicode destination.

How to convert uppercase to lowercase in Excel simple and fast Picture 5

Step 4: Then the program will appear the message ' Successfully converted RTF clipboard ' then click OK to close them.

How to convert uppercase to lowercase in Excel simple and fast Picture 6

Step 5: Go back to the Excel File that you want to convert text, right-click and then select Paste (Ctrl + V) that paragraph in and you will have the results as shown below.

How to convert uppercase to lowercase in Excel simple and fast Picture 7

Finally, you have succeeded by converting uppercase to lowercase with Unikey.

Just a few Excel tips you can simply convert uppercase to lowercase. I wish you success with LOWER () and use Unikey to convert uppercase to lowercase.

3.7 ★ | 7 Vote

You should read it

May be interested

  • Simple way to convert Excel files to PDF - Convert directly or use softwareSimple way to convert Excel files to PDF - Convert directly or use software
    converting excel files to pdf will help create more professional documents, preventing spreadsheets from being modified during the exchange process. so how to convert excel to pdf?
  • How to transfer unsigned text with UnikeyHow to transfer unsigned text with Unikey
    in addition to supporting vietnamese typing, unikey also has many other supportive office functions such as converting text, converting from uppercase to lowercase and vice versa, converting from accented words to unsigned ... in the article below, we will guide you to convert text from accented to unsigned.
  • How to convert CSV files to Excel in bulkHow to convert CSV files to Excel in bulk
    with just a few simple operations, we can batch transfer csv files to excel.
  • How to create drop down lists in ExcelHow to create drop down lists in Excel
    how to create drop down lists in excel. to limit the typing of misspelled data and the same information but the data is not identical due to the person entering at uppercase, sometimes lowercase or extra spaces that make the statistics error, therefore, when designing a data entry, every employe
  • How to convert MKV to MP4 is simple, fast and high qualityHow to convert MKV to MP4 is simple, fast and high quality
    how to convert mkv to mp4 is simple, fast and high quality. mkv is a high quality video format with great sharpness and of course the capacity will also be heavier than mp4. with its high popularity, most electronic devices support video playback
  • 3 Ways to Convert CSV to Excel Successfully3 Ways to Convert CSV to Excel Successfully
    csv is a popular data format but it is not easy to work with without the right tools. this article will guide you through the simple and optimal way to convert csv to excel, helping you quickly summarize data.
  • How to convert a CSV file to ExcelHow to convert a CSV file to Excel
    how to convert a csv file to excel. csv stands for comma separated values, which is a simple text format where values ​​are separated by commas. both csv and excel are files that help store data in spreadsheets. however, csv also has advantages and disadvantages compared to excel software. t
  • How to convert Vietnamese accented into unsigned very fast like UnikeyHow to convert Vietnamese accented into unsigned very fast like Unikey
    for some reason, you need to convert your vietnamese text from signed to unsigned. very simple and extremely fast, you do not need to manually type back. in this article, guide you how to convert vietnamese accented into unsigned very fast
  • 3 simple ways to convert Excel files to Word that you should know3 simple ways to convert Excel files to Word that you should know
    you need to convert data from excel files to word but don't know what to do? don't worry too much, today's article will show you 3 simple and effective ways to convert excel files to word on your computer.
  • How to convert Excel to PDF keeping the formattingHow to convert Excel to PDF keeping the formatting
    converting excel files to pdf is very simple, this article will show you 3 fastest ways to convert from excel to pdf without losing formatting.

Office information