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.

Try the TRIM function.

select column
then data /text to columns
select fixed width
click finish