moving data from single to multiple columns?

[mzimmers]

Hi -



I received some data from an email. When I copied it, and pasted it into Excel, it put everything into one column. Is there some slick way to tell Excel to move the data into seven columns? R1C1 stays as is, R2C1 goes to R1C2, R3C1 goes to R1C3, and so on, starting over with the 8th row.

Alternately, is there a better way to import the data so this would be unnecessary?

Thanks.