Excel 2003 act differently from Excel 2000

P

pkenchatt

I have a small program that drops text from a Word table into Excel
using Paste Special as Text.

So although Paste Special as Text should insert the contents of the
clipboard as text without any formatting this does not appear to be
happening as it did with Excel 2000

Excel 2003 splits the data when it meets a New Line or Carriage Return
and drops anything after it down to row below.

Any ideas what is causing this behaviour
Thanks for your assistance
Phil
 

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Changes in How Code Acts After Upgrade of Excel 2
Paste Special as Text 0
nk into onenote 2016 paragraph from excel 2016 cell 0
Load data from Word into Excel 7
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010 2
Pasting Between Excel and Word 1
Excel 2003 with VBA - "Can't find project or library" 6

Top