View Single Post
 
Old 08-28-2021, 05:57 PM
jorgon jorgon is offline Windows 10 Office 2019
Novice
 
Join Date: Aug 2021
Posts: 1
jorgon is on a distinguished road
Default

Hi Igu

I had the same issue when I needed to include line breaks in material linked-in from an Excel cell to Word. Strangely, if there was a line break then the material appeared in quotes in Word.

The above was happening when using "paste special", "paste link", "unformatted text", but did not do so when choosing "formatted text (RTF)" or "HMTL format". These worked fine despite no RTF or HTML formatting in the source. Using the RTF version changed the switches to "\a \f 4 \r " and I noticed that these switches survived both further formatting in Word of the whole paragraph into which the material was inserted (causing the MERGEFORMAT switch to be added), and also survived saving the Word file and returning to it later.

Altering the switches manually having made them appear using Alt-F9 however, only worked temporarily and did not survive saving the word file and returning to it later. I believe Word must identify that the Link switches have been changed, and if so removes it altogether when saving. If this theory is correct then the only way to get the switches to work without adding quotation marks if the source cell has a "new line" is to use either of the above options in paste special.
Reply With Quote