Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2023, 10:40 PM
soroush.kalantari soroush.kalantari is offline How to get away with extra space when linking from excel to word? Windows 10 How to get away with extra space when linking from excel to word? Office 2016
Competent Performer
How to get away with extra space when linking from excel to word?
 
Join Date: Jun 2021
Posts: 115
soroush.kalantari is on a distinguished road
Default How to get away with extra space when linking from excel to word?


I am used to link excel cells to word document through Past/ Past Special/Past link/Formatted Text(RTF). Sometimes(not always) in this process, an extra space is created and when I update the link all the text in the line the excel link is situated, jump to next immediate line. (see the attached picture. The Highlighted part). Can you guide me on how I can get away with this extra space?( I have attaced Excel file. I link from G column. I have this problem with cell (g12))
Attached Images
File Type: png extraspace.PNG (9.9 KB, 14 views)
Attached Files
File Type: xlsm contracttemplate.xlsm (29.9 KB, 1 views)
Reply With Quote
  #2  
Old 05-16-2023, 07:04 AM
Charles Kenyon Charles Kenyon is offline How to get away with extra space when linking from excel to word? Windows 11 How to get away with extra space when linking from excel to word? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Your link is going into its own paragraph. That is the space you have highlighted.

When you insert a cell, I believe this is inevitable. (I do not know because I do not use this method.)

With Mail Merge you could insert the content only as merge field.
Mail merge using an Excel spreadsheet - Word
Reply With Quote
  #3  
Old 05-16-2023, 08:30 PM
soroush.kalantari soroush.kalantari is offline How to get away with extra space when linking from excel to word? Windows 10 How to get away with extra space when linking from excel to word? Office 2016
Competent Performer
How to get away with extra space when linking from excel to word?
 
Join Date: Jun 2021
Posts: 115
soroush.kalantari is on a distinguished road
Default

@Charles Kenyon, thank you for your reply. I should work with "mail merge" feature for a while to see if it can does the job for me or not.
Reply With Quote
  #4  
Old 05-20-2023, 08:00 PM
soroush.kalantari soroush.kalantari is offline How to get away with extra space when linking from excel to word? Windows 10 How to get away with extra space when linking from excel to word? Office 2016
Competent Performer
How to get away with extra space when linking from excel to word?
 
Join Date: Jun 2021
Posts: 115
soroush.kalantari is on a distinguished road
Default

@Charles Kenyon, thank you for your reply. your method works and solved the problem
Reply With Quote
  #5  
Old 05-22-2023, 10:50 AM
Charles Kenyon Charles Kenyon is offline How to get away with extra space when linking from excel to word? Windows 11 How to get away with extra space when linking from excel to word? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Glad I was able to help.
Reply With Quote
Reply

Tags
link, past

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing extra space between word BillMcEnaney Word 9 02-16-2023 11:03 PM
How to get away with extra space when linking from excel to word? Trouble with extra blank space on line when using "Chapter" Headings in Microsoft Word chudlerk Word 4 11-10-2021 11:27 AM
How to delete extra space (between lines)? Gerald Wilhelm Word 15 08-26-2020 04:08 AM
How to get away with extra space when linking from excel to word? An html link from Excel works, but now there is too much extra space in the cell njweatherdon Word 2 09-22-2014 09:06 PM
extra space before equation Nice2007 Word 1 04-27-2012 05:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 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