Hello

Can somone help me figure out how to do the following?

Need to check if a cell is over 100 characters and if so, truncate what is over 100, insert a new cell underneath it and, append the excess to the new cell.

It needs to make sure to preserve whole words (making sure not to break a word while truncating).

Any help appreciated.