Splitting Columns at nth character and at a word break

I have a program that I can only enter a max of 200 characters into a field but have many entries that have too large of fields. What I need to do is split the column into two different fields that each have less than the 200 characters. I don't however just want to separate by character count alone and be left with one of the fields that starts mid word from field one.

I hope all of that make sense.

Thanks for the help

The formulae in B5 and B7 of the attached workbook split a long text field in B3 at the first space less than 200 characters.

Hope this helps.

Pete