Split A List my Space in adjacent Columns

Hi I have a Column of over 2,000 rows. Each field has a string of words (like a Sentence). I want to run a code that scrolls down the list and splits out each individual word in the string into the adjacent column.

I have attached an example with the following code.

The splitting element works and so does the range. What I can't get to work is the result being outputted next to each line.

Appreciate any help. Still learning...

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

Regards Mick

Perfect. Thank you MickG

You're welcome