Do you struggle with formatting your text in an Excel sheet? Worry not, because in this article we will show you quick and easy ways to change text from upper to lowercase and vice versa in Excel.
Method 1: Using the UPPER and LOWER Functions
The UPPER function helps to convert all the text in a selected cell or range of cells to uppercase, while the LOWER function helps to convert all the text in a selected cell or range of cells to lowercase. Follow the simple steps below to understand how to use these functions:
Step 1: Highlight the cells that you want to convert.
Step 2: In the formula bar, type in “=UPPER(A1)” (without the quotes), where A1 is the first cell in the range you want to convert to uppercase.
Step 3: Hit enter. You should now see all the text in the selected range converted to uppercase.
Step 4: To convert the same text back to lowercase, simply type in “=LOWER(A1)” (without the quotes), where A1 is the first cell in the range you want to convert to lowercase. Hit enter and you should now see all the text in the selected range converted to lowercase.
Method 2: Using the Text to Columns Feature
The Text to Columns feature can be used to separate text that is in one cell across multiple cells, and can also be used to convert the text to uppercase or lowercase. Follow the simple steps below to understand how to use this feature:
Step 1: Highlight the cells that you want to separate or convert.
Step 2: Click on the “Data” tab in the ribbon at the top of the screen.
Step 3: Click on the “Text to Columns” button.
Step 4: In the wizard that appears, select “Delimited” and click “Next”.
Step 5: Select the delimiter that separates your text (e.g., space, comma, semicolon) and click “Next”. If your text is not separated by a delimiter, select “Fixed width” instead.
Step 6: In the next screen, you can select the format that you want each separated column to be in. To convert the text to uppercase or lowercase, select the appropriate option and click “Finish”.
FAQ
Q: Can I convert a range of text to title case?
A: Yes, you can use the PROPER function to capitalize the first letter of each word in a selected cell or range of cells. Follow the steps below:
Step 1: Highlight the cells that you want to convert.
Step 2: In the formula bar, type in “=PROPER(A1)” (without the quotes), where A1 is the first cell in the range you want to convert to title case.
Step 3: Hit enter. You should now see all the text in the selected range converted to title case.
Q: Is there a shortcut to convert text to uppercase or lowercase?
A: Yes, there is a shortcut to change the case of selected text in Excel. Simply highlight the text you want to change, and then press “Shift + F3”. This will toggle the case of the selected text between uppercase, lowercase, and title case.
Conclusion
Now that you’ve learned a couple of methods to change text from upper to lowercase and vice versa in Excel, hopefully, you will save some time in formatting your spreadsheets. Remember to always double-check your work after using any automated function, as errors may occur.
If you’re interested in learning more tips and tricks for Excel, be sure to check out our Youtube channel, where we post regular tutorials and walkthroughs.