Microsoft Office Forums Quotation marks in text linked-in from Excel

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2016, 08:41 AM
Igu Igu is offline Quotation marks in text linked-in from Excel Windows 7 64bit Quotation marks in text linked-in from Excel Office 2007
Novice
Quotation marks in text linked-in from Excel
 
Join Date: Dec 2016
Location: Germany
Posts: 2
Igu is on a distinguished road
Default Quotation marks in text linked-in from Excel

I have a Word file with some content linked-in from Excel:




{LINK Excel.Sheet.8 "C:\\Users\\tjgx84\\Documents\\Integration\\Angebo te.xlsx" "Supp_Data!R7C4" \a \t}


Everything works fine as long as the text in Excel does not contain a line break.

With a line break (Alt+Enter in xls) the text shows up with quotation marks, like this:



"This text comes from a Excel cell


and has a line break."


The quotation marks are really annoying and after a lot of trying and googling I start to think this is a bug.


I tested a lot of possible switches, such as \h, \p, \f4, \f5, \x,
\* MERGEFORMAT but none of them seems to work at all.

Thx in advance to whoever can help.
Reply With Quote
  #2  
Old 12-06-2016, 01:30 PM
macropod's Avatar
macropod macropod is offline Quotation marks in text linked-in from Excel Windows 7 64bit Quotation marks in text linked-in from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,655
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I'm not seeing that behaviour in Office 2010 (I don't have an Office 2007 installation to test with). Have you tried repairing the Office 2007 installation (via Word Options|Resources|Diagnose)? Is your Office installation fully updated?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-07-2016, 11:59 PM
Igu Igu is offline Quotation marks in text linked-in from Excel Windows 7 64bit Quotation marks in text linked-in from Excel Office 2007
Novice
Quotation marks in text linked-in from Excel
 
Join Date: Dec 2016
Location: Germany
Posts: 2
Igu is on a distinguished road
Default

I'm working on a company issued pc which gets regular updates via a push service. Manual updates are disabled. MS Word 2007 shows 12.0.6758.5000 SP3 MSO 12.0.6755.5000
Reply With Quote
  #4  
Old 02-28-2017, 12:21 PM
Ozoro Ozoro is offline Quotation marks in text linked-in from Excel Windows 7 64bit Quotation marks in text linked-in from Excel Office 2010 64bit
Novice
 
Join Date: Feb 2017
Posts: 1
Ozoro is on a distinguished road
Default

I had the same issue and just resolved it.

The key is to click in the text in Excel. I found this behaviour in text cells that had a line break in them. For example, imagine the quotation marks in the following do not exist:

"Text like this will not produce quotation marks"

"Text like this WILL produce quotation marks
"

To remedy this place your cursor on the line break in Excel and press delete to eliminate it. Both the quotation marks and line break in Word will disappear on next update.
Reply With Quote
Reply

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


All times are GMT -7. The time now is 12:36 PM.


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