Paste Special as Text
 

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

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