I want to in an instant put a list of 1000 name & addresses in single cells of their own in excel

xor · #1 09-15-2017, 02:04 AM

I think that with Excel 2013 you will have to use some VBA code as shown at this link (at the bottom):

https://answers.microsoft.com/en-us/...158d67d?auth=1

and then use a formula like:

=TEXTJOIN(" ",TRUE,OFFSET($A$1,(ROW(1:1)-1)*3,,3))

(with your data as from A1 and downwards).

In office 365 Excel there is a built-in function TEXTJOIN so here you don't need the VBA code.

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