In article ,
nickr1954
wrote:

Actually, there are no blank rows between the rows of data.

In that case, you can skip steps 3 and 4.

It is one continuous string.

If you mean that each row is one continuous string and are not in
separate columns, as I assumed, put them in different columns first and
then use the formula I offered. To separate your text string in
separate columns...

1) Select your range of cells

2) Data Text to Columns

....and follow the prompts.