how to remove space

I have one excel sheet. In sheet no of customer name approx 6000 customerlist.

I want to remove space after finishing of complete name. Attach file for your ready reference. If you press F2 on customer name to see after completed name one space show. Let me know the how to remove in one attempt to remove those space gap. Any forwmula or any trick. Cofirm per return.