Problem: I have data in lower case. I need to convert it to upper case.
Strategy: To solve this in Excel, follow these steps:
- Insert a new blank column to the right of your data.
- Use a formula such as =UPPER(D2). To convert to lower case, use =LOWER(). To convert to Proper case, use =PROPER().
- Copy the temporary formula down to all rows by double-clicking the fill handle.
- The entire range of new formulas will be selected. Press Ctrl+C to copy.
- Press the left arrow to move to the original data. Right-click and choose Paste Values.
- Fix in a temp column.
- You can now delete the temporary column D.
Additional Details: I to bring up the "W" program again, but here is another place where Microsoft Word could make this easier. If you had an entire table that needs converting, select the whole table, paste to a blank word document, then use the Change Case dropdown in the Home tab.
After the conversion is done, copy from Word and paste back to Excel.
- Word.