Paste Special into Word from Excel

[Guest]

I currently have an issue when using 'Paste Special' in Word to paste information from Excel

I am using the 'Paste Special' function and selecting 'Paste Link' using 'Formatted Text (RTF)' to paste information from a merged cell

I have found that as the cell I am pasting from is actually 3 merged cells (with the text being in effect in the first cell) that when the data goes into Word it inserts 2 Tab spaces after the cell contents (pressumably one for each cell)

I am finding this very annoying, has anyone got any ideas how I can get around this

Thanks

 

[Cindy M -WordMVP-]

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

Which version of Word? Why are you using RTF instead of HTML? With which command, very exactly, did you merge the cells in Excel?

I currently have an issue when using 'Paste Special' in Word to paste information from Excel.

I am using the 'Paste Special' function and selecting 'Paste Link' using 'Formatted Text (RTF)' to paste information from a merged cell.

I have found that as the cell I am pasting from is actually 3 merged cells (with the text being in effect in the first cell) that when the data goes into Word it inserts 2 Tab spaces after the cell contents (pressumably one for each cell).

I am finding this very annoying, has anyone got any ideas how I can get around this ?

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

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

 

[Guest]

Thanks very much for your reply, in answer to your questions :

I am using Word and Excel 97.......

In Word 97 using 'Paste Special' there is not an option to paste HTML......

The cells in Excel were merged by highlighting them, right-click and format cells, Allignment and then merge.

Regards

 

[Cindy M -WordMVP-]

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

I am using Word and Excel 97.......

In Word 97 using 'Paste Special' there is not an option to paste HTML......
Understood...

The cells in Excel were merged by highlighting them, right-click and format

cells, Allignment and then merge.The RTF conversion formats are a bit older than this Excel command. And the
HTML format was probably introduced in Word 2000 (I thought it was 97, but
apparently my memory is starting to slip).

In this case, assuming you're really wanting to center something across these
cells, try using the older technique from before Excel had a "merge cells"
capability:
- select the cells and undo the merge
- with the cells still selected, Format/Cells and from the Horizontal list
"Center across selection".

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

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