seperate words in a text string


Posted by John S on October 10, 2001 12:48 PM

If you were going to seperate the following string of words(which exists in one cell) into individual cells. How would you do it

Posted by Addition on October 10, 2001 12:52 PM

A1 =apples oranges grapes
A2 =pears grapes banannas



Posted by Aladin Akyurek on October 10, 2001 1:08 PM

Text To Columns, with space as delimiter. (NT)