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.

You can copy the data and while pasting choose a single cell and then Edit/Paste Special and choose Transpose.

Also have a look at:
Data -> Text to Columns -> (Wizard)

Either the option Delimited or fixed width should suite you, depending on your data.

Dario

I don't get Transpose as an option for Paste Special; all I get is the option to paste it as Unicode. (I'm cutting from Mac Mail, BTW.)