Remove extra spaces

I have a list with 1200 names. All the names unfortunately have a space on the end and I need to use them in a mail merge, but right now because of the space, the mail merge looks like this: Dear John Doe ,

I want it to look like this: Dear John Doe,

Isn't there a way to do this in one shot? Otherwise I'm going to have to do F2, backspace, enter, F2, backspace, enter...... 1200 times :'(

Edit: I found how to do this, but by solving another problem I was having. All the names were capitalized and I learned how to use the =PROPER() formula, which also removed the extra space for me. I love this site already :D