Are you using office 2010 still?



If you are pretty basic i would actually go with the text to columns version


Just highlight the column you want to split, click text to columns and use space as the delimiter