I managed to hobble together some code from bits and pieces that will pull the last word off of a cell value, insert a row underneith and place the word in the new row.
This is the beiginning I guess... I still need to figure out how to add some math functions. Need to see if 1 word pulled out of the string will bring the length down to 100 characters, and if not, take off more words as needed. Also need to check the newly created cell's length to see if the appended words will cause that row to go over 100 characters and adjust.
Any help appreciated.