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!
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
How to change uppercase and lowercase letters in Excel
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.
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.
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.
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!
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
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
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
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
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
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
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?
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
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
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?
Now, research has proven this theory, illustrating that changing passwords frequently leads to security problems.
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
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
Recently, NASA has released many clear images of different regions in the universe taken by the world's largest telescope, James Webb.