Alright, here we go... I have no idea where to start because I am not
to familiar with excel vba programming. But let me try and explain
what the situation is to the best of my ability. I have a page of
addresses that was scanned and converted over to word with some image
to text software. Then I got it into a text file and finally a csv
file. Its in this format most of the time:
Examples-
Row 1 - ABEL, Mary-Fund Mutual Grp, Tec Clms
Row 2 - Expert, PO Box 1621, Houston, TX 77054
Row 3 - P555-621-7474, F555-218-1998
Row 4 - ARLINGTON, Kyle-Full Ins Grp, Clms
Row 5 - Expert, 2800 Post Oak Blvd, Houston, TX 77056
Row 6 - P664-621-7474, F665-218-1998

(the number of rows in between each address sometimes varies)

and I need it in this format:
Row 1 - ABEL, Mary-Fund Mutual Grp, Tec Clms Expert, PO Box 1621,
Houston, TX 77054, P555-621-7474, F555-218-1998
Row 2 - ARLINGTON, Kyle-Full Ins Grp, Clms Expert, PO Box 3434,
Houston, TX 77054 P664-621-7474, F665-218-1998

All one line and 8 columns. I figure it would be easiest to write a
script that loops through the csv file and searches for a text that
only has letter characters and all caps in the front of the row...
which would be the Last Name field also which is always in the front.
Then in between each it removes the "returns". I don't know if I was
clear enough or if someone needs further clarification by all means...
I am absolutely stuck and I really would appreciate any help or
guidance on the situation! I have looked at other examples of looping
a csv file... it seems pretty basic, but this to me is a little mind
boggling.

Thanks for any help!!

-Matt P