If I have a bunch of text in a cell, is it possible to extract each individual word into an array? If so, how would I do it?

There are never any commas or other symbols in the text - just words separated by a space. So, for example "This is my text" Would be converted into an array ("This", "is", "my", "text")

My final goal is to put this text into a column in a worksheet so that cell A1 = "This", A2 = "is", and so on.

Thanks