Its still a bit confusing, but I think I've got it... Colo's HTML Maker is a great tool for conveying things like this (link at bottom of this page).

BUT If I understand you correctly, there should be a way.

I would first set up a matrix of cells that give you the starting locations of each line and word. So assuming A1 is

Code:

`1500 Rent 100,Water 200,Insurance 1200`

Then in A2 place 1 and A3 place

Then drag that down.

Then In B2 place

Code:

`=IF(Find(" ",$A$1,A2)<$A3,Find(" ",$A$1,A2),50000)`

and drag this down and across.

Now in either a ways down or a ways to the right place formulas based off of these. You could use

Code:

`=MID($A$1,A2,IF(B2=50000,$A3,B2)-A2)`

And drag that down and across.

Anyway,

HTH, (I haven't tested it yet, as I'm on a linux machine right now, so you have to make either +1 or -1 adjustments to either the Starting or the Length of the Mid Statement)

~Gold Fish