Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
0013
 
Posts: n/a
Default Extra space when pasting link from excel to word as unformatted te

I'm having a problem with pasting links from excel to a word document. I'm
using Office 2003

I have a budget in Excel and I'm putting together an executive summary in
word. I want to link all of the numbers in word to the excel workbook.

For example, I want to write:
"Expenses in the Americas are xx%."
where the "xx" is a number linked from excel.

I copy the cell that has the number in excel, go to word and choose paste
special. I then select the paste as link option and choose unformatted text
from the list box.

This works fine except that in addition to the number, additional spaces are
also inserted. I can delete these, but they come back when I update the
link. So the sentence ends up looking like:
"Expenses in the Americas are xx%."

How do I get a link to just the number and not the extra spaces?

Thanks in advance for any help.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 11:59 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"