How to change uppercase and lowercase letters in Excel

Video How to change uppercase and lowercase letters in Excel

Sometimes when editing in Excel, we sometimes make lowercase errors, which is very inconvenient when we have to delete and type again. That's why Microsoft has given people a number of special functions that can make this job easy and fast. The following invite you to see the article on instructions for converting uppercase and lowercase letters in Excel.

Download Microsoft Office 2016 Download Microsoft Office 2019

1. Turn uppercase and lowercase letters in Excel with the Upper function

Upper is a built-in function in Excel that helps you convert character strings from lowercase to uppercase.

Formula of the function : Upper (Text) .

+ Where Text is the text to be changed.

Here are the steps for the function:

Step 1: Select a blank cell, here will display the results.

Step 2: In this blank box, we type the syntax of the function. We drag the mouse down to display the remaining cells.

How to change uppercase and lowercase letters in Excel

In addition, everyone can switch from uppercase to lowercase.

2. Change uppercase and lowercase letters by the Lower function

The Lower function is a built-in function that is similar to the String and Text functions , but it converts characters from uppercase to lowercase.

Syntax of the function: Lower (Text) .

Steps to use the function:

Step 1: Click a blank cell, with this box we will get the results after the change.

Step 2: Here, you enter the syntax of the function. 

How to change uppercase and lowercase letters in Excel

People can't turn all the letters in the string from uppercase to lowercase and vice versa, but we also have to turn the words into lowercase with the first letter capitalized.

3. Change uppercase and lowercase letters using the Proper function

Proper is a function that helps people change lower case letters but capitalized at the first letter.

The formula of the function: Proper (Text) .

Here's how to do it:

Step 1: Click on a blank cell, here the result will be displayed.

Step 2: Here, we will type the formula for the function.

How to change uppercase and lowercase letters in Excel

Above are the functions that help people convert uppercase and lowercase letters in Excel, hopefully these will be things that make our process of work easier and achieve high results. Good luck!

Sign up and earn $1000 a day ⋙

Leave a Comment

Fix the error of speaker icon with red X, computer has no sound

Fix the error of speaker icon with red X, computer has no sound

If you see a red X icon on the volume icon in the system tray, it means you can't use your audio device. Check out these 4 fixes!

Things you may not know about reindeer

Things you may not know about reindeer

Reindeer are Santa's main mode of transportation, but it wasn't until 1823 that he had a reindeer sleigh team. Here are some weird and wonderful facts about these Arctic animals.

Facts about the flu you may not know

Facts about the flu you may not know

Influenza is a contagious respiratory illness that can cause symptoms including fever, cough, chills, body aches, and fatigue. Flu season occurs every year and the virus can spread quickly.

How to Create Pixar Style Characters with ChatGPT

How to Create Pixar Style Characters with ChatGPT

Following the trend of creating unique Ghibli style art and toy action figures, in this article you will be guided to create Pixar style characters.

Latest Fantasy of Light Codes and How to Redeem Codes

Latest Fantasy of Light Codes and How to Redeem Codes

Code Fantasy of Light gives players a series of attractive rewards, including gold coins and Purple Crystals for you to use.

Infinity Squad DTCL season 8.5: Team formation, build, gameplay

Infinity Squad DTCL season 8.5: Team formation, build, gameplay

In general, Infinity Squad DTCL, like many other squads, cannot evaluate many combinations because there are not many BĐVC squads tested. However, this will probably be the most popular clan in the upcoming Infinity Squad.

How to make dishwasher cleaner at home

How to make dishwasher cleaner at home

Dishwashing liquid can be made at home if you are not sure about the quality of products on the market. Below are detailed instructions on how to make dishwashing liquid at home.

How to Use Technology to Overcome Procrastination

How to Use Technology to Overcome Procrastination

Procrastination is not just a bad habit, it's a way of life that some people spend years trying to break. Everyone wants to be more productive, but it's not easy.

Should I buy a USB, Bluetooth or NFC security key?

Should I buy a USB, Bluetooth or NFC security key?

Using a computer security key is the best way to authenticate your identity, but not all security keys are created equal. USB, NFC, and Bluetooth security keys all have their own advantages and disadvantages.

Reasons not to delete your old device from Find My Device

Reasons not to delete your old device from Find My Device

Even if you no longer use your old device, you should keep it registered on Find My Device for the following reasons.

ICloud email address can now be changed

ICloud email address can now be changed

Apple has just announced a much-anticipated feature on iOS 18.1 that brings joy to iPhone and iPad users, which is the ability to change iCloud email address.

Why is changing your password regularly not a good idea?

Why is changing your password regularly not a good idea?

Now, research has proven this theory, illustrating that changing passwords frequently leads to security problems.

Why is space a vacuum?

Why is space a vacuum?

The universe is an almost absolute vacuum. Why is that? Let's learn about the vacuum of the universe together!

The Legends Behind 6 Haunted Shipwrecks

The Legends Behind 6 Haunted Shipwrecks

Whether real shipwrecks or ghostly phenomena, these ships carry tales of unexplained deaths, flying orbs, and screams from the depths of the sea.

Admire impressive space photos from the $10 billion telescope

Admire impressive space photos from the $10 billion telescope

Recently, NASA has released many clear images of different regions in the universe taken by the world's largest telescope, James Webb.