spilt words

Hi i've got one cell with the following: Sittb 3rd Nov - 18:28 A5 480m

I'm looking to split it up so that each word is seperate.

Any ideas?

Try using Data > Text to columns with space as a delimiter

That does what i want except the data gets updated anywhere between 1min and 20 mins so would need to do it manually or set up macro where is i don't want a macro if can get away with it