Paste Special in Office XP

[Guest]

Following issues the other day surrounding 'Paste Special' using Word and Excel 97 I have now had my Office Suite upgraded to XP

I am using 'Paste Special' to link information from Excel to Word

If I use 'Paste Special' and select HTML to do the following 'Hello how are you' and then type in a comma after it in Word, when I save the document the comma and following text moves onto the next line in the Word document when it is re-opened and the links are updated

I do not want this to happen, has anyone got any ideas

Thanks in advance....

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGFwcGll?=,

HTML inserts Excel data with formatting, and this includes the
information that the Excel information is part of a TABLE CELL. In order
to carry this information across and display it in Word, the LINK field
that maintains the link has to have a paragraph mark before and
following the Excel data. There's no way to suppress this. You'd have to
use the "plain text" format to get the Excel text to be "inline" with
other Word text.

Following issues the other day surrounding 'Paste Special' using Word

and Excel 97 I have now had my Office Suite upgraded to XP.

I am using 'Paste Special' to link information from Excel to Word.

If I use 'Paste Special' and select HTML to do the following 'Hello

how are you' and then type in a comma after it in Word, when I save the
document the comma and following text moves onto the next line in the
Word document when it is re-opened and the links are updated.

I do not want this to happen, has anyone got any ideas ?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail