I have spaces following names in my cell, how do I delete them?

L

LostandConfused

I have around 1000 rows with names in each cell. There appears to be extra
spaces following each name. How can I easily delte all these spaces without
backspacing each one?
 
P

pinmaster

Try this:

Select your data, next go to Data/Text to columns, select "Fixed width" and
hit "Finish"

HTH
Jean-Guy
 
Top