How to make cleaning fun
Cleaning doesn't have to be a chore if you know how to make it fun. Here are some simple ways to make cleaning fun.
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!
What is the Infinity Fortress in Demon Slayer?
Demon Slayer: Infinity Fortress is getting a lot of attention from fans. So what's inside Demon Slayer's Infinity Fortress? Let's find out together!
ChatGPT May Be Running Silently on Your Phone and How to Fix It
Background Conversations keep a user's conversation with ChatGPT going while using other apps or when the screen is off. This means ChatGPT can listen or monitor a user's phone usage behavior 24/7.
Googles Gemini Responds With Weird, Repeated Nonsense Words to Some Users
Recently, some users noticed that Google Gemini has been giving repetitive text, weird characters, and complete nonsense in some responses.
Full code of Luc Tung Tam Quoc latest and instructions to redeem code
Code Luc Tung Tam Quoc gives new players everything they need to start their journey.
Code Giang Ho Ngu Tuyet and how to enter code
Giang Ho Ngu Tuyet is an MMORPG game based on the five elements of mutual generation and mutual inhibition. With 5 sects: Shaolin, Minh Giao, Vo Dang, Duong Gia, Thien Nhan based on the five elements of Metal, Wood, Water, Fire, Earth.
MIUI 13 Wallpaper, MIUI 13 Wallpaper
MIUI 13 wallpapers with many different wallpaper themes from abstract to landscape, combined with vivid and attractive colors for users to choose from.
How to fix Your virus & threat protection is managed by your organization error
What do you need to do to resolve the error Your virus & threat protection is managed by your organization?
How to fix Chromebook not turning on
If your Chromebook won't turn on, you're probably feeling frustrated and hopeless. Luckily, many of the reasons why a Chromebook won't turn on are easy to fix.
Why should you always check app permissions before pressing install?
Taking a moment to review your app permissions can save you a lot of privacy and security problems later on!
How to play Rengar DTCL season 14, standard items, lineup...
Rengar DTCL season 14 will play the main assassin role, with the ability to jump to the enemy with the lowest health and deal strong physical damage.
Can autism be detected based on facial features?
Using facial features to detect autism is a growing area of research. While it can aid in diagnosis, much of the research remains unreliable.
10 types of diseases caused by technology, only appear in modern people
Technology brings convenience and unlimited connectivity, changing everyone's lives but also bringing diseases that were never seen before.
How to move purchases between 2 Apple accounts
If you've purchased apps, subscriptions, music, videos, or other content from one Apple account, you can now transfer purchases to another Apple account when needed.
How to hide personal information of photos on phone
Skitch application on Android, iOS will edit images including the feature of blurring out personal and confidential information in the image.