414766 Excel File Data Entry - EASY

I have 2 excel files. One has 1,510 rows of email addresses (Music Recording Studios). I need a semicolon added to the end of each email address. I've done it to the first one so you can see what I want. The second has 3,655 rows of email addresses (Music Instrument Sales). Again, I need a semicolon added to the end of each email address. In addition, the first 200 listed have an extra space at the beginning that I need removed. I've done the first one as an example. I've attached both files in a rar file. This is an easy 10 rating for someone. Money goes in escrow and is released upon me having the completed files. Thanks!