Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-19-2015, 01:59 PM
mruetz mruetz is offline Strange Issue with Excel Linked Data in Word Windows 7 64bit Strange Issue with Excel Linked Data in Word Office 2007
Novice
Strange Issue with Excel Linked Data in Word
 
Join Date: Dec 2011
Posts: 10
mruetz is on a distinguished road
Question Strange Issue with Excel Linked Data in Word

I have been working on this report in Word where is has linked values from Excel and all has been going fine until I ran into this situation.

I have some text in a cell in Excel for example as follows:
This is sentence 1. This is sentence 2.
It is linked to Word and displays fine in Word, as you would expect:
This is sentence 1. This is sentence 2.
If I change, the data in Excel to put in hard return between the 2 sentences (by hitting Alt-Enter). The data in Excel looks now like this:
This is sentence 1.
This is sentence 2.

However, when I update the link in Word it put quotes around the item:
"This is sentence 1.
This is sentence 2."

Is there anyway to supress these quotes. It has me stumped. If I remove the hard return in Excel and I update the link in Word the quotes go away. Any ideas?



Thanks, Matt
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Excel Object - Resizing Issue Element PowerPoint 0 02-26-2015 04:16 AM
Word 2010 Field widths from linked Excel data. DPB Word 1 06-25-2014 09:31 PM
Strange Issue with Excel Linked Data in Word data linked from excel sheet megatronixs Word VBA 1 08-19-2012 11:09 PM
Strange Issue with Excel Linked Data in Word Excel data using mailmerge issue kilosub Mail Merge 12 05-05-2011 12:27 AM
Problem with Covnverting Linked Excel Data to Text trapdoor Word 0 05-25-2009 07:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 AM.


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