I think this is very simple, but I'm stumped on what formula to use.

Say cell A1 has the following text: "It rained today"

I want "It" (the first word) to be in cell B2, "rained" to be in cell C2 and "today" to be in cell D2 - no quotes of course.

I do not want to use VBA/code please.

Manually I would normally use the Text to Columns feature under the Data menu, but special circumstances don't allow that this time (I need the text to be parsed automatically), so I must have formulas sitting in B2, C2 and D2 that automatically parse the words.

A max of words 3 will be in cell A1, A2, A3, etc. and the words will always have 1 space between them.

Please help. I really need this tonight.