copy/paste text in Excel 2000

Giganews Newsgroups
Subject: copy/paste text in Excel 2000
Posted by:  Doug (d_macgow…@yahoo.com)
Date: Wed, 29 Oct 2003

We have multiple users of MS Excel 2000.  Some of them,
when copying four distinct lines from a text-only file:

  twinkle
  twinkle
  little
  star

and paste it into cell A1 of an Excel 2000 worksheet, it
will paste all four lines into A1 and expand Row 1 to fit
all four lines.

Some people, however, are copying from the same text-only
file and then pasting them into cell A1, and the first
line of text appears in A1, the second line of text
appears in A2, the third line of text appears in A3, etc.

What do we need to do in order to have all 4 lines paste
into just A1?

Replies