hi friends,
I have created an Excel file in which the hundred of names are listed. I want to make the first letter of every word in the file in capital form. It would take a considerable time to manually navigate each and every word in the file and change the first letter of the word to uppercase.
Can anyone provide me the macro code so that I can easily capitalize the first letter of every word in excel ?
thanks....
Bookmarks