Module or method to parse cell info to new rows

Hi,
I have a ss with basic info in row, (name,phone etc) and there is also a memo field which is comprised of datetime stamped notes.

I need to parse the memo field to insert a new row and copy fill in the leading info from the original line. So example, there are 3 notes in the memo field, the module would parse the second note to a new row, copy the name etc, then parse the the third note to new row and copy, and continue on down through the ss. (Or something like this).

Hope someone can help,

thanks,

John

There is white space, Im guessing a carriage return and line feed.

Thanks

John