Change Case in Excel
You have come across with this situation many times in routine life, that you have large list of names with all Uppercase or Lowercase. It is very difficult and hectic to edit every cell manually to correct their first name and last as proper case.
Thankfully, there are some easy formulas in excel to convert text from capital to lower case, lowercase to capital case, lower and capital case to proper case.
In this post, we will take a look into some excel functions that will help us to change case in excel.
Change case from Lowercase to Uppercase
- Select the cell where you want the converted text.
- Use” =”
- Type “UPPER”
- Start Bracket “(“
- Select the cell, needs to be converted.
- Close bracket “)”.
- Press Enter.
- Copy and paste as text to remove the formula.
Change case from Uppercase to Lowercase
- Select the cell where you want the converted text.
- Use” =”
- Type “LOWER”
- Start Bracket “(“
- Select the cell, needs to be converted.
- Close bracket “)”.
- Press Enter.
- Copy and paste as text to remove formula.
Change case from Mix case to Propercase
- Select the cell where you want the converted text.
- Use” =”
- Type “PROPER”
- Start Bracket “(“
- Select the cell, needs to be converted.
- Close bracket “)”.
- Press Enter.
- Copy and paste as text to remove formula.
I hope, this post will help you a lot. Using these simple functions of excel, can make our work easy and we can finish it in short span of time.Otherwise, doing it manually, by editing every single cell, can be very time consuming and painful.
Keep visiting for more excel tricks and shortcut commands. We keep updating our pages with latest updates.
Read more..
Play Video