 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Reorder a CSV file...Anyone?
How can I reorder a CSV file (in Excel) in which names and addresses are held? Each name and address is on an individual row, with the name and each line of a particular address in a separate column. I wish to reorder this matrix of data so that it can be transferred to Word with the names and addresses appearing as though they would on an envelope (i.e. below each other) viz: Name Address1 Address2 Address3 Rather than: Name Address1 Address2 Address3 I'm using Word & Excel 2003. > How can I reorder a CSV file (in Excel) in which names and addresses are > held? [quoted text clipped - 17 lines] > > I'm using Word & Excel 2003. Search Word help for "Mail Merge." You may need to add a header row to the Excel spreadsheet. I've done this with mailing labels but it should work for envelopes, too. Bill Thanks for the pointer Bill. Worked like a dream! >> How can I reorder a CSV file (in Excel) in which names and addresses are >> held? [quoted text clipped - 24 lines] > > Bill Bill, Name and address information is not normally stored in the label layout you ask for. The best solution would be to keep it in the table format it's in, where it's much more useful, then use Word or Access to make labels when you need them, from the table.  SignatureEarl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- > How can I reorder a CSV file (in Excel) in which names and addresses are held? > [quoted text clipped - 16 lines] > > I'm using Word & Excel 2003. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.