It has been a while since I used excel to any extent. I have numerous files that were converted from PDF to Excel. There are two columns, Last Name and First Name. When they converted all the letters in each column were capitalized. Is there a way (macro or function) I can use that will leave only the first letter upper case and the rest lower case that I can apply to the entire worksheet or each column?