Have you tried Format Cells/ Alignment/ Wap text?
How long are the text strings you are pasting in?
--
David Biddulph

"scottymoore14" wrote in message
...
When pasting a numbered list of interview responses from word to excel
using
the paste special - text option I get one column with the number and one
column with the text, which is what I need. However, in some cells, the
text
is cut short leaving me with responses that end in mid sentence. I'm using
office 2003 products.