• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Change Case in Excel

Home » Excel » Excel Tips » Change Case in Excel

By Tejswini Bhosale Leave a Comment

chnage case in excel

Table of Contents

  • Explanation of Change Case in Excel
  • How to Change Case in Excel

Changing Case of Text in Excel

Excel provided a set of options to deal with text. But, there is a problem with Excel, it does not have the option to change the case of the text in excel worksheets. It provided three major functions to convert the text to lower case, upper case, and proper case. The function includes PROPER, UPPER, and LOWER. These are helpful in minimizing the problems in changing the case. In this article, we will learn how to change text case in excel.

Functions used to Change Case in Excel

Following are the functions used to change text case in excel

#1 – Lowercase in Excel

To convert all the text presented in a cell to lowercase, a LOWER function is helpful. To use this function, the following parameters and formulas should be used.

change case 1

#2 – Uppercase in Excel

To convert all the text presented in a cell to uppercase, the UPPER function is helpful. To use this function, the following parameters and formulas should be used.

change case 2

#3 – Proper Case in Excel

To convert all the text presented in a cell to the title case, PROPER function is helpful. To use this function, the following parameters and formulas should be used.

change case 3

Only one cell should be selected to apply the change case functions. When a formula is entered hover is displayed by mentioning the purpose of the function. After entering a formula, the ENTER key should be pressed on the keyboard to have the desired result.

How to Change Case in Excel?

The change case functions are used in two ways in Excel.

  • First method: Directly entering the function name in a cell as shown in the below figure
  • Second method: Inserting the functions from the Formula Tab.

The following are some examples to understand how to change case in excel.

Example#1: Change Text to Lowercase Using LOWER function

The following example is considered to explain the use of the LOWER function. Several steps are required to display the text in the required format.

Step1: Select the cell where you want to convert text case in excel into lower case

Example 1.1

The above figure shows the sample data to convert into a lower case. The formula of the lower function should be entered into the highlighted cell.

Step2: Go to the top of the ribbon and click on the Formula tab to select the function as shown in the image. The description for the LOWER (text) is displayed by hovering on the function.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Example 1.2

Step3: Once you click on a LOWER function, the function argument window will open.

Example 1.3

Step4: Cell address should be entered into function arguments box and results are displayed in the figure.

Example 1.4

Press Enter to see the change in text case in excel.

Example 1.5

Step5: Formula is dragged to apply to the remaining cells to convert data presented in the next rows.

Example 1.6

Example#2: Converting Text to Uppercase Using UPPER function

The following example is considered to explain the use of the UPPER function. Several steps are required to display the text in the capitalized format

Step1: Select the cell where you want to convert into upper case

change case example 2.1

The above figure shows the sample data to convert into the upper case. The excel formula of the upper function should be entered into the highlighted cell.

Step2: Go to the top of the ribbon and click on the Formula tab to select the function as shown in the image. The description for the UPPER (text) is displayed by hovering on the function.

change case example 2.2

Step3: Once you click on an UPPER function, the function argument window will open. The UPPER function is found from the several functions available

change case example 2.3

Step4: Cell address should be entered into function arguments box and the result is displayed in the figure

change case example 2.4

Press Enter to see the change in text case in excel.

change case example 2.5

Step5: Formula is dragged to apply to the remaining cells to convert data presented in the next rows.

change case example 2.6

Example#3: Converting Text to Title case Using PROPER function

The following example is considered to explain the use of the PROPER function. Several steps are required to display the text in title case.

Step1: Select the cell where you want to convert into title case

change case example 3.1

The above figure shows the sample data to convert into title case. The formula of title function should be entered into the highlighted cell.

Step2: Go to the top of the ribbon and click on the Formula tab to select the function as shown in the image. The description for the PROPER (text) is displayed by hovering on the function.

change case example 3.2

Step3: Once you click on a PROPER function, the function argument window will open. PROPER function is found from the several functions available

Example 3.3

Step4: Cell address should be entered into function arguments box and the result is displayed in the figure

Example 3.4

Press Enter to see the change in text case in excel.

Example 3.5

Step5: Formula is dragged to apply to the remaining cells to convert data presented in the next rows.

Example 3.6

Example#4: Changing the Text Using the Flash Fill Method

Step1: Type the data in lower case to convert into upper case

change case example 4.1

Step2: Type the same data in a highlighted cell in UPPER case and press ENTER to move the cursor to below cell

Upper case

Step3: Go to the ‘Data’ tab and click on the ‘Flash Fill’ option under the Data Tools Group. The remaining data is automatically typed by converting into the UPPER case as shown in the below figure

Flash Fill

Things to Remember Here

  • The change case functions such as LOWER, UPPER, and PROPER are not worked on the numerical data, special characters, and punctuations.
  • When a PROPER function is used, the S letter after the apostrophe is converted into the uppercase. Here‘s’ letter should be converted manually into the lower case.
  • The change case functions accept only one input at a time. It is hard to change the case of text presented in all cells
  • There is no option to select only the particular text to change the case

You can download this Change Case Excel Template from here – Change Case Excel Template

Recommended Articles

This has been a guide to Change Case in Excel. Here we discuss how to Change Case in Excel using 1) Lower Function 2) UPPER Function 3) PROPER Function and 4) FLASH FILL with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Insert Delta Symbol in Excel using Shortcut Key
  • Examples of $ Symbol in Excel 
  • Excel Chi-Square Test  Examples
  • ToolBar on Excel
  • How to Separate Text in Excel?
  • Add Text in Excel Formula
  • Wrap Text Excel
  • Convert Text to Numbers Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Excel Tips

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Limited Period Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More