parsing a text string within length parameters but at word breaks

[Joel Becker]

I have strings of text up to 200 characters that I want to parse into multiple cells a maximum length of 35 characters. I want to break the text at the nearest full word such that the text is <= 35 characters. I can use the MID command however that parses mid-word. Any help is appreciated.