In Excel 2003... I've got a column with several items (between 0 and 7
items) delineated by commas. I need to be able to break out the various
items into adjacent cells (so that, for example, if the original data
is in column A, the first item would be in column B, the second (if
present) would be in column C, etc.

The kicker is that I can NOT do this using the Tools: Text to Columns
wizard. This is something that needs to recalculate in real-time, as
the items in column A change (they feed in from another sheet in the
workbook).

I've made some progress using a combination of MID and FIND (keying in
on the commas), with different formulae in columns B-H (one for the
first item, one for the second, one for the third, etc.) but I've only
gotten the first one to work properly.

Anyone ever done anything like this before?

Joe Bloch