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, 03:28 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
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]
Reply With Quote