It would depend on how the data is laid out.

If all the addresses were 8 rows with row 1 mapped to the same column, row 2 to
the next column, ..., row 8 to the 8th column, then either a macro or formulas
could be used.

If the number of rows varied, but there was an indicator (blank row between each
group), then that would be a different solution.



unrhyll wrote:

I have a Word mailing list (8 rows, 2 columns on each page) which I want to
convert to an Excel mailing list. I can paste it into the spreadsheet but I
want to avoid having to cut and paste all the addresses into the Excel
address fields. Is there any easy way of converting it?

--

Dave Peterson