If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Any way to copy two paragraphs from one cell to multiple cells?
It's no fun in the shallow end
If you look at the Edit Paste Special choices you will see that HTML is the default (which I presume is what you get from Paste) but you are looking at the Text from your DataObject. However, the Paste As Unformatted gives different behaviour in 2000 and 2003. Getting way out of my depth too (I suspect Graham Mayor may know something of this if he's watching) but I think there have been changes in conversions to and from text formats between releases. An interesting side note - copying a couple of small paragraphs in 2000 (on ME) gave me 45K of clipboard data. Roughly the same in 2003 (on XP) gave me about 4.5K. Have to go out for most of the rest of the day now but I will investigate some more later. -- Enjoy, Tony "Greg" wrote in message oups.com... Tony, It also seems to be version dependent. The results I reported yesterday was from Word2003. Same test today in Word2000 the results are totally different. In 2000 the Chr(13) are not picked up even when present and the Chr(10) is not appended. Selecting the first word "Test" and the second word "Test" without the paragraph mark returns: 84|101|115|116|84|101|115|116 So if I select "Test" Paragraph Mark "Test" the resultant .GetText string is "TestTest." I wonder how Word then determines where to put the paragraph mark back in that string when it performs a paste. Obviously I am in an area over my head here. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy/Paste how to avoid the copy of formula cells w/o calc values | Dennis | General Discussion | 10 | March 2nd, 2006 10:47 PM |
How to copy single cell into cell that is merged from two cells? | Rod | General Discussion | 3 | January 22nd, 2006 09:24 PM |
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Tourcat | Worksheet Functions | 1 | February 8th, 2005 06:26 PM |
Combining data (numeric format) in multiple cells into one cell (t | GNAC SID | General Discussion | 2 | February 7th, 2005 04:09 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |