Need help in formatting Excel files
I had posted the following help message in the wrong section. Sorry about that.
Can someone please help me to do the following in my Excel files. I have created a number of Excel files from the original files by deleting some columns that are not needed in the file. I find that the text in the newly created files (rows 5 and 6) are in upper case like the original files. I do want to change the text into proper case. For example, I want to convert “UNIVERSITY OF MARYLAND” into “University of Maryland”. I know how to do this column by column (there are 8 columns in my data file). But I want to write a macro so that I can do the formatting into Proper case globally. Is it possible to highlight the row and make the change I am looking for only once?Thank you very much.Angela