• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Easy Case Converter Logo 60

EasyCaseConverter

Online Case Converter Tools

  • Home
  • Blog
  • About Us
  • Contact Us
  • Privacy Policy

How to Change Case in Excel?

May 29, 2020 by adminecc

In the previous article, we discuss how to change Case in Word. But this article, we will explain how to Change Case in Excel.

For your information, in this article, we use Microsoft Excel from Office 356.

Different from Microsoft Word, to change sentence case, we can do easily by using the Font Options or Sentence Case Button.

In Microsoft Excel, to change from one Case to another Case need to use a function. The subsequent section will explain how to change a mixed Case to lowercase, uppercase, and proper case.

To do this, you need to create a 4 x 6 table in excel, as shown in the figure below.

Microsoft Excel Table – EasyCaseConverter.com

The first column will fill by names with mixed case. The second until the fourth column will show the names with lowercase, UPPERCASE, and Proper Case, consecutively.

The example of names:

  1. LiAm BuRn
  2. NoAh WaTsOn
  3. WiLlIaM wHiTaKeR
  4. aLeXaNdEr WiLeY
  5. mIcHaEl HoLlOwAy

Change Mixed Case to lowercase

Change Case to lowercase – EasyCaseConverter.com

The “LOWER” function is required to change case to lowercase. The “LOWER” function takes one argument, which is a text.

In our example, the text that we want to change to the lowercase locates in column A2, A3, … A6. So all you need to do is fill the function argument with the column name as follows:

=LOWER(A2)

Change Mixed Case to UPPERCASE

Change Case to UPPERCASE – EasyCaseConverter.com

The “UPPER” function is required to change the case to uppercase. The “UPPER” function takes one argument, which is a text.

=UPPER(A2)

Change Mixed Case to Proper Case

Change Case to Proper Case – EasyCaseConverter.com

A PROPER function will change every first character of a word to UPPERCASE.

The “PROPER” function is required to change the case to a proper case. The “PROPER” function takes one argument, which is a text.

=PROPER(A2)

Related posts:

Easy Case Converter - Microsoft WordHow to change sentence case in Microsoft Word? Change Case to Lowercase and Uppercase in Python

Powered by YARPP.

Filed Under: article

Primary Sidebar

Easy Case Converter Tool
Easy Case Converter - Free Case Converter Tools

Easy Case Converter, Free Online Case Converter Tools

Easy Case Converter is a free online converter case tools to convert your text into any formatted case.

Change Case to Lowercase and Uppercase in Javascript

This article explains how to change case to lowercase and uppercase in Javascript. Javascript has two methods to change a string to lowercase and uppercase, called toLowerCase() and toUpperCase(), respectively. The toLowerCase() The toLowerCase() is a built-in method that returns the calling string value converted to lowercase. The following Javascript code is an example of […]

Change Case to Lowercase and Uppercase in Python

This article explains how to change case to lowercase and uppercase in python. Python has a built-in method related to string handling. You are not only can check whether the string is lowercase or uppercase, but you also can change a string to one of these case characteristics. In this article, we will explain four […]

How to Change Case in Excel?

In the previous article, we discuss how to change Case in Word. But this article, we will explain how to Change Case in Excel. For your information, in this article, we use Microsoft Excel from Office 356. Different from Microsoft Word, to change sentence case, we can do easily by using the Font Options or […]

Copyright © 2019 EasyCaseConverter.com