Hi All

The code is very useful, thanks!!

Ive stumbled upon a requirement where in the Split Texts need to be pasted in the cells adjacent to the source cell.
As in when text is present in
A1 like "Hi My name is John, i live way back up in the woods in the evergreens, where stood a long cabin, and im a country boy who cannot read and write so well but i can play a guitar just like a ringin a bell"
In B1 the text should be "Hi My name is"
in B2 the text should be "John, i live"
in B3 the text should be "way back up in"
and so on.

Also if I take the input via a userform TEXTBOX, is there a code that will post the lines to destination cells in the above format?
When the input is the Userform1.Textbox1.Text,
the out put should be printed in the cells of column B.


Could please help with this?
Thanks in advance