Platform: Windows 2000/Excel 2000


Is there anybody out here who is able to help me solving following
Excel-case, I am a novice using VB therefore I hope you are a little passion
with me:

I have an Excel-file consists of approximately 56000 rows and 10 columns,
one of these columns (lets say column E) contain a description of characters
from 0 to 80.

I need Visual-basic to go through each cell in column E and divide the text
into two "lines" first "line" can maximum consist of 40 characters the
second "line" has no maximum. My problem is that the text often will be
divided in middle of a word that I do not want.
Therefore I imagine the program first check on character 40 if it is a
"space" or not. If it is a space nothing has to be done opposite the program
must go back through the text from character 40 until it meet a space.
Afterwards it shall put in "spaces" from the found space up to characters
40.

That is all what I need.

JIP