well, there is a method, very easy:
select your range to split, then on Data tab, Data instruments-text to column....
folow the menu, and select your separator.. in you case, it' s a space..
your range is now separated in next columns, each word or numbers in a column