Your question leaves many interpretations.

You copy and paste then manipulate into the order you want.

Manipulation depends upon how the dat is pasted into Excel.


Gord Dibben MS Excel MVP



On Wed, 11 Jul 2007 14:04:03 -0700, Medman
wrote:

How do I convert mass data such as address lists into Excel? I have lost my
info from doing this before and realize it is not a simple copy and paste
operation. Thanks