Limit merged cell data; Place excess into next merged cell down

I have a series of merged cells that i have set to format the text to the top left, and set to multiline.

However i want to (if possible) set any charaters that will be > 3 lines(3 lines of text fits in cell height) to be auto placed into the next merged unlocked cell down.

Is there way to do this say via the Worksheet Change event, either as the user is typing, or on exit of the cell?

I think i solved it with the below, where 52 is the maximum number of charaters placed in a cell:

Please Login or Register  to view this content.

It seems to place all the charaters >90 into the cell offset(1,0) {down 1} and plave a dash in front, and remove the excess(>90) characters that were placed into the offset cell.

Not sure if there is a way to improve this by finding the excess characters in the word, and move whole words down instead of being based on the actual charaters.