[MsNovi]

I need help with a rather complex macro and would appreciate anything I can get.
I have a spreadsheet containing a lot of text. Whenever there is a “~” character, need to remove the ~ and in effect do a line feed. For example if I have some text like so:

This is sample text. ~ This is some more text.
Here is even more text that would be in other cells.

I need it to be modified like so:

This is sample text.
This is some more text.
Here is even more text that would be in other cells.

Breaking it down this means I have to be able to find the ~ character, create a new row, delete the ~, and then copy everything after the ~ into the new row.

I have tried many different things with varying degrees of success, but none of my efforts can do exactly what is needed. I can get new rows inserted, but then it will sometimes stop at the first ~ it finds. Other times I was able to do multiple lines, but not multiple cells in the same row containing ~. I could never figure out how to copy the remaining cells down to the next row.

Thanks in advance for any help you can provide.