ExcelBanter - View Single Post

Ron Rosenfeld

On 5 Sep 2006 13:39:48 -0700, wrote:

Thanks Ron.

By the way, the example I gave just puts it into sequential columns.

To put it into different cells, the third argument ...,columns($A:A)) is the
index number to tell which "word" to parse out. When you drag it across the
row, it reduces to 1 or 2 or 3 or n depending on where you are.

So the first word, that argument would be a 1; word 2 -- 2; etc. You can hard
code it if my method is not appropriate.

--ron