Hey All,

I'm attempting to split a single cell with character counts that vary.

I have the text in B2; in C2 and over I have a formula that breaks up the data into 80 piece blocks

=MID($B2,80*(COLUMN()-3)+1,80)
What I'd like this to additionally do is only parse the data to full words under 80 characters and add a space.

Example:

"The Store Owner Is Really Creepy"

for ease lets say this is parse every 8 characters:

The Stor e Owner Is Reall y Creepy
The Store Owner Is Really Creepy

Saying the bottom is how I'd like to to parse, I hope that makes sense.