View Single Post
 
Old 12-06-2016, 08:41 AM
Igu Igu is offline Windows 7 64bit Office 2007
Novice
 
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