Splitting text in cells based on criteria.

[Wamhoi]

Hi all,

I'm trying to break up text in excel based on certain criteria and would prefer using a formula.

Criteria one: Must be 35 characters or less in length
Criteria two: Must include full words

So for example:

Cell A1: Sally bought a new purse

End Result:
Cell A1: Sally bought a new purse
Cell B1: Sally bought a (assume 35 characters)
Cell C1: new purse (assume 35 characters)

As mentioned earlier the only caveot is that it cannot break individual words IE: "Sally bought a ne"

 

[Wamhoi]

I did have troubles with the first formula but wanted to attempt to fix it before replying back but your previous reply did the trick!

Thanks again. It was so much help!