I need to be able to type a string in a cell and based on the total number of characters I've typed, have code place the remaining characters over the total allowed in a cell below. If the cell below is not blank, I would need a cell inserted below by shifting cells up, not adding an entire row. Here is is in more detail.

If cell begins with " or |-, then count total number of characters.
If character count is > 15, then take the remaining characters and move them to the line below.
Precede the characters with |-
If line below is not empty, insert cell below and shift other cells down (can't override data in cell)
Continue this until the original character string is completed.

In case that wasn't entirely clear, here is an example.

I would type it in like this: "Enter Width of Cal At Plane Point ?"

It needs to be separated like this:

"Enter Width Of "
|-"Cal At "
|-"Plane Point ?"

I am using an excel sheet as a sort of pseudo compiler to write code for a calculator. The calculator can only take a certain amount of characters per line in it's programs including the "'s and |- (apend) symbols. This gets pretty tedious to keep track of manually, so I would like to us vba to monitor all cells in one column and control this. It would be great to just type the text string and have it make the changes automatically.

Thanks for your time.
Josh