Herbert,
Yes, our assumptions are somewhat different. Each cell in column A may have
a different number of entries. Whereas you assume each cell has the same
number of entires (i.e., 4). Otherwise, we are in sync with everything else
you mentioned.
Is there a way to modify your formula to reflect my assumption?
Thanks again for all your help.
Bob

"Herbert Seidenberg" wrote:

Here is my setup. Maybe we assumed different initial conditions.
A1 thru A5 has this arbitrary text data:
A531, A493, C941, D526
G988, G400, H552, B584
F542, C723, H958, G598
K384, H410, C993, H223
E378, A721, C642, E549
After Text to Columns, I get at A1 thru D5:
A531 A493 C941 D526
G988 G400 H552 B584
F542 C723 H958 G598
K384 H410 C993 H223
E378 A721 C642 E549
I named A1:D5 arrayB. Verify that the Name Box shows this.
The formula entered at A15 and dragged down to A34 gave this:
A531
A493
C941
D526
G988
G400
H552
B584
F542
C723
H958
G598
K384
H410
C993
H223
E378
A721
C642
E549