Forum Discussion
Case
I was sent a large exel program that is 1/2 upper case and 1/2 lower case. I must be stupid because I have been trying to change it all to lower case or capitalize each word only - to no avail. What can I do? I have tried 4 or 5 different ways that are shown on line.
Thank you,
Diana
1 Reply
If you have a large Excel file with text that is a mix of uppercase and lowercase, and you want to change it to either all lowercase or capitalize each word, you can use the following methods:
Method 1: Changing to All Lowercase or Uppercase
Open your Excel file.
Select the range of cells containing the text you want to change.
Click on the "Home" tab in the Excel ribbon.
In the "Font" group, you'll find buttons for changing the case of the text.
To change the text to all lowercase, click on the "a" button.
To change the text to all uppercase, click on the "A" button.
The selected text will be converted to the chosen case.
Method 2: Capitalizing Each Word
Open your Excel file.
In the first cell of the new column,
enter the formula =LOWER(A1) or =PROPER(A1),
where A1 is the cell containing the text you want to change.
Then, drag the formula down to fill the rest of the cells in the new column.
This will convert all of the text in the original column to lowercase or capitalize the first letter of each word.
These methods should help you change the case of the text in your Excel file. If you're encountering any specific issues or errors, please provide more details.
