View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnW JohnW is offline
external usenet poster
 
Posts: 6
Default extracting from 1 collumn mailing list

Hello,
I have an extracted file where the mailing list is in one collumn.
eg. the name, address1, address2, address3 and blank line is repeated down
the page. Just like a lable printout.
Is there a way of selectively copying all names to 1 row, address1 to the
next row, address2 to the next and so on.
I think it is in a format of copying every 5th line to a collumn?
That way I'll have 4 collums of data.