I have text cells that are up to 60 characters in length that I need to break
into 2 separate cells, each cell can be up to 30 characters long without
splitting up any words. So, if the 30th character splits a word, it should
split to the second cell at the previous space.

How do I set up a formula to do this? I figured that if I wanted the first
30 characters, I could use the formula (if the text was in A1) =LEFT(A1,30).
But this splits any words.

Thanks in advance!