Thread: [Solved] I want to in an instant put a list of 1000 name & addresses in single cells of their own in excel
View Single Post
 
Old 09-14-2017, 02:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Put the name & address parts in different columns on the same row. That is how such data are normally stored; it will also facilitate your randomisation, since you can randomize by row.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote