|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
09-14-2017, 03:28 PM
|
||||
|
||||
The way I suggested can be achieved through an Offset formula in A1 on a new worksheet:
=OFFSET(Sheet1!$A$1,(ROW()-1)*2+COLUMN()-1,0) copied to B1, then down as far as needed (~500 rows). Your preferred method entails editing every entry...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
| Tags |
| microsoft excel |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to copy addresses in word document to excel/mailmerge list | msnarayanan | Mail Merge | 4 | 10-17-2015 03:17 PM |
| 2 Email Addresses/ 1 Contact List | Mister Mobius | Outlook | 0 | 06-22-2015 07:56 AM |
| Need help making labels from Single Column Word file of addresses | genoMU69 | Mail Merge | 1 | 06-26-2014 03:33 PM |
| Why can't I sent emails to addresses not in my contact list? | jdavy | Outlook | 1 | 12-12-2010 09:05 PM |
| Creating a Map From a List of Addresses | aleccamp | Excel | 0 | 11-19-2005 03:04 PM |
I want to in an instant put a list of 1000 name & addresses in single cells of their own in excel
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode