I have to split an 80 character text string into two 40 character fields. But it needs to be done like line wrap, not splitting a word. I am not too concerned with the second field running over the 40 character.

Can someone help this Excel VBA newbie?

Thx