How to Change from Lowercase to Uppercase in Excel?
1. Open the file.
2. Write formula =Upper(A1) (A1 is cell location)
3. Press enter.
4. Click bottom right corner of cell.
Drag box to the bottom of column.
5. Copy it.
6. Open ms word.
7. Paste it in word.
8. Copy it.
9. Delete words in excel.
10. Right click. Click on paste special.
11. Select text.
12. Click on ok.
Use PROPER(A1) For proper name function.