I need to have a formula similar to:
=LEFT(E52,70)
but I need to make sure that it does not break up word.
IE...make a formula choose the word that is less than 70 characters long and
everything before it.

Then...I need the next cell below it to show the rest of the text string to
a point

Basically...I am trying to wrap text without wrapping text into one cell and
use multiple cells.

Is this possible