Quote Originally Posted by darkyam View Post
If the entries are all only one word each, use =Substitute(A1," ","") and copy down, then copy all of these and paste over the original data as values and delete this column.

If they have multiple words, use the formula =IF(RIGHT(A1)=" ",LEFT(A1,LEN(A1)-1. This assumes there is only one space at the end of these words.

*Edit: Too slow, apparently. If only one space, omletto's suggestion is better. Silly me, I keep trying to do things with formulas.
Still tho like that second one for if i have two words. Both of these should easily help. Thanks both