Office 2000 Paste Special (Formatted RTF) Truncates

S

Steve Needham

When copying from a cell in XL and pasting to Word, PowerPoint or WordPad by selecting PASTE SPECIAL and FORMATTED TEXT RTF, truncates any character string to 1024 characters. The clipboard viewer shows all the text is in the clipboard.

Does anyone know of a fix?
 
G

garfield-n-odie

Hi, Steve. If you paste as unformatted text, you should get the entire character string. If you past as RTF, you get 1024 characters. That's because an Excel cell can contain a maximum of 32,767 characters, but can only display a maximum of 1,024.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Copy/Paste (Clipboard) Issues 1
Paste to excel from word - auto format problem 1
255 truncation 1
Visio shape text disappears upon copy paste 1
paste special macro stops working when run a 2nd time 1
Mail Merge with Excel and Word 2007 1
Can't past web page text into MS Word 1

Top