Thread: [Solved] Organise cells with line break into separate rows
View Single Post
 
Old 09-24-2018, 05:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
There is no paste option for doing what you want; not only do you want each of the cells with line-breaks to become separate rows, but you also seen to want the data from other columns on the same row replicated in those new rows.

A macro could be used to undertake the task but quite different macros would be required for Word and Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote