I have 2,300 names in individual cells. Before the person's first name, there's an annoying "space." I guess because this information was brought over from another program.

i.e. space John Smith

I need to eliminate that space. However, there is also a space between the first and last name that I need to keep. Any ideas?

Thank you in advance,
GSG