How can I remove a space from my cells?

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I have a few thousand names in a worksheet and some of them have a space in
the beginning of the name that I want to get rid of.

Example: (notice the space before the "J")
John Doe

How can I get rid of all these?

thanks.
 
Wow, I have no idea what I just looked at on the site...

All I want to do is remove one space from the left in column A. Can someone
post the forumula? Thanks.
 
Back
Top