Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2014, 03:00 PM
DPB DPB is offline Word 2010 Field widths from linked Excel data. Windows 7 64bit Word 2010 Field widths from linked Excel data. Office 2010 64bit
Novice
Word 2010 Field widths from linked Excel data.
 
Join Date: Jun 2014
Posts: 1
DPB is on a distinguished road
Default Word 2010 Field widths from linked Excel data.

Hi everyone,



This is my first post, and I have searched for a solution before posting but that search has proved to be unsuccessful.

I have a Word Document with linked Excel Fields that are incorporated into a report (past special as Linked Unformatted). My problem is that one of the fields (as seen in the screenshot linked below) as 'Tuesday 1 January 2013' has extra space at the end of the field that pushes the text in front of it. I've tried everything to get the field to be like the date field before it (Sunday 1 January 2012) without any spaces, but just can't seem to get rid of those extra spaces.

I've tried re-pasting, I've tried reformatting the Excel cell to make it text, even, in desperation, applied TRIM to the text field, and yet I still get the extra spaces. I also notice that SOME of the other numeric linked fields also have a single extra front an back space, but the 'Ģ777,398.02' doesn't have any. There seems to be no rhyme or reason as to the spacing in the fields.

I would be extremely grateful if anyone could kindly offer a solution.

With many thanks

DPB

Reply With Quote
  #2  
Old 06-25-2014, 09:31 PM
macropod's Avatar
macropod macropod is offline Word 2010 Field widths from linked Excel data. Windows 7 32bit Word 2010 Field widths from linked Excel data. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,950
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

When you use a field to link from Word to Excel, you get all of the data in the Excel cell. Evidently some of your Excel cells have extra white space in them. The link fields cannot remove that and Word doesn't have a TRIM field that could do the job. Consequently, you need to fix the issue at its source (i.e. in Excel).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
excel 2010, linked values, word 2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? GracieB Word 7 10-02-2013 06:24 AM
Word 2010 Field widths from linked Excel data. data linked from excel sheet megatronixs Word VBA 1 08-19-2012 11:09 PM
Pasting linked Excel pie charts into Word Paul-NYS Office 0 07-01-2011 06:56 AM
Excel File as Linked Object in Word jfitch Word 0 03-18-2010 11:44 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 08:07 PM.


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