Split string after spaces

[NichoD]

Hello, I have several strings in column B. For all cells in column b with more than one space I want to split the string.

For example;

B2: Hello Bye

this should be split to

B2: Hello
C2: Bye


How should I make this code? Thanks in advance.

 

[JvdV]

Use a build-in wizard called Text-To-Columns, you'll find it in the 'Data' tab.

 

[NichoD]

Thank you so much!