search and extract within text

I have to a cell "A" holding full description of an item, the description
can be as long as 80 characters. I need to break the descritption into 3
separate columns, with the one column holding the first 30 characters,
second column 20 characters, and last column 30 characters. Each column must
have complete nouns only, I cannot pull partial words from the description
(A) column.

thank you.

s,

Please clarify...
Must all of the text break at a space?
If a word extends, even one character, beyond the limit must it then go in the next column?
What does your code look like so far?

Jim Cone
San Francisco, USA

"sunnyday"
<sunnyday@discussions.microsoft.com>
wrote in message
news:22969439-22BA-4238-A612-0133E28CFABD@microsoft.com
I have to a cell "A" holding full description of an item, the description
can be as long as 80 characters. I need to break the description into 3
separate columns, with the one column holding the first 30 characters,
second column 20 characters, and last column 30 characters.
Each column must have complete nouns only,
I cannot pull partial words from the description (A) column.

thank you.