Data that has been imported into Excel often has poor formatting. Text can be displayed all in uppercase or lowercase. You could retype the text manually or you could use the Text functions Proper, Upper or Lower to do this for you. If you found this video helpful, read the full article @ http://www.microsofttraining.net/b/blog/excel-training/how-to-change-case-text-in-excel/
Click Follow to gain access to more Microsoft Office Tutorials