Pasting text into one cell (Excel wants to dump in multiple cells)?

[Bridget]

<lol> I can't believe I've never asked this one either?
Opportunity never came up ...

Every once in a while I need to paste paragraphs of text
into an Excel cell (i.e., comments from one source into a
log). And Excel naturally takes the data and puts each
paragraph into its own cell even if in same column.

Is there a way for Excel to ignore all the hard returns as
prompts for a new cell and instead to treat them as
ordinary returns so that I get the comments in paragraph-
form into one cell?

I hope my question is clear (?). <g>

Thank you!

 

[Andy B]

Hi

Before you paste, hit F2 on the cell (edit mode). I think this will chuck
the whole paste into one cell!

 

[Bridget]

WELL, D'UH!!! <rofl>

Why didn't I _ever_ think of that??!!!

Thanks, that did the trick!

D