LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting if data from one collumn is present in another collumn Amelia Excel Worksheet Functions 1 February 8th 07 10:05 PM
Mailing list Roger Excel Discussion (Misc queries) 1 May 11th 06 08:29 PM
Need help with mailing list Howie J. Excel Discussion (Misc queries) 0 January 3rd 06 05:08 PM
Mailing List woodstock New Users to Excel 2 May 4th 05 03:06 AM
Use of Excel for Mailing List tjd Excel Discussion (Misc queries) 2 December 14th 04 12:10 AM


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"