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.

search and extract within text
 

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"

wrote in message

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.