Hi
I have an Excel spreadsheet with names and addresses which I want to mail merge into a letter on word (annual benefit statements).
The names and addresses on Excel have been imported from system software and are all in capitals. Is Excel smart enough to be able to keep the first letter of text in a cell but to change the remaining letters to lower case?
Cheers,
Bookmarks