LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kevin VanHalen
 
Posts: n/a
Default Converting a large vertical mailing list into a horizontal format

I've copied a vertical list of over 1000 customers ID #'s, names and
addresses and pasted the info into column A in Excel. This info will be
transferred to a letter for each customer. For this to work effeciently the
customer info needs to be sorted horizontally in specific columns.

Example: A B C D
98-2004 John Doe 5555 Road Lane Town, State 77777

I know how to do these individually, but what is the method to do this more
quickly?
Thank you so much for your help!
 
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
Excel column headers to a vertical list Carole O Excel Discussion (Misc queries) 1 April 27th 05 11:01 PM
How do I search a mailing list spreadsheet to remove entries alre. RagDyer Excel Discussion (Misc queries) 1 March 28th 05 09:29 PM
which is best for mailing list management, Outlook or Excel? Thrival New Users to Excel 1 March 4th 05 07:55 PM
How can I combine 3 separate mailing list? Baylynx New Users to Excel 3 February 1st 05 04:53 PM
how do I convert a list in Excel to mailing labels mcguff Setting up and Configuration of Excel 1 November 29th 04 03:58 PM


All times are GMT +1. The time now is 07:10 PM.

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"