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.