Thread: [Solved] Row seperator control character in Text To Table
View Single Post
 
Old 04-11-2019, 07:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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
You can't specify a row delimiter - paragraph breaks and line breaks alike are treated as row delimiters. If you need to preserve line feeds and the like, temporarily replace them with another character (e.g. Find = ^p, Replace = ^0182, Find = ^l, Replace = ^0167), then convert them back again once the table has been created.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote