Use the `UPPER` function to convert text to uppercase: `=UPPER(A1)`
Use the `LOWER` function to convert text to lowercase: `=LOWER(A1)`
Use the `PROPER` function to capitalize the first letter of each word: `=PROPER(A1)`
Enter the formula in a new cell
Press Enter
Copy the formula down for other cells if needed
Copy the results
Paste Special as Values to replace the original text if needed
Use Flash Fill to manually create the desired case pattern in some versions of Excel
Use the Change Case option in Microsoft Word if you need to edit text there first and paste it back into Excel