• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Text Cases

Effortlessly Convert Text Cases in Excel with These Methods

February 1, 2023 by Admin Leave a Comment

In this post, we will explore the different methods you can use to convert text cases in Excel and provide step-by-step instructions to help you get started.

UPPER

The UPPER function is used to convert text to uppercase. The syntax is simple: =UPPER(text). To use the UPPER function, simply select the cell that contains the text you want to convert, then type =UPPER(A2), where A2 is the cell reference of the text you want to convert. The result will be displayed in the formula bar and can be copied and pasted as values to permanently change the text.

LOWER

The LOWER function works similarly to the UPPER function, but converts text to lowercase instead. The syntax is =LOWER(text). To use the LOWER function, select the cell that contains the text you want to convert, then type =LOWER(A2), where A2 is the cell reference of the text you want to convert.

PROPER

The PROPER function is used to convert text to proper case, which means that the first letter of each word is uppercase and the rest of the letters are lowercase. The syntax is =PROPER(text). To use the PROPER function, select the cell that contains the text you want to convert, then type =PROPER(A2), where A2 is the cell reference of the text you want to convert.

Here is the screenshot of sample data after applying all the text cases functions

Filed Under: Excel Tagged With: Text Cases

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023