Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-28-2021, 05:57 PM
jorgon jorgon is offline Quotation marks in text linked-in from Excel Windows 10 Quotation marks in text linked-in from Excel 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Straight Vs Curly Quotation Marks FOsmund Word 4 04-16-2015 01:48 PM
Quotation marks are inserted in wrong font sinz54 Word 5 01-11-2015 06:34 PM
Can't find space before closing quotation marks wardw Word 7 01-16-2014 12:13 PM
How do I select everything that is in quotation marks? Jophassa Word 4 09-02-2011 10:57 AM
Quotation marks in text linked-in from Excel problem with automatic formatting on quotation marks Bobosmite Word 3 05-27-2010 07:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft