how to separate sentence in excel to one column?

Question

I am looking for a way to separate text to one column (column A) so each word will be separate.

I have searched filmier questions in stack overflow and all the questions are about how to spread the words width.

This is how it should look like in the end. Result

Thanks

Answer 1

The easiest, well an esay way would be using the stock text to columns function that excel has. Select the cell that has the sentence and then under the data tab click text to columns, select delimited and then use space as the delimiter. It is a bit more basic than using some code.

Answer 2

Here is some code that goes into a module code sheet.

     

This is how it looks in the end.