View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Murf Murf is offline
external usenet poster
 
Posts: 4
Default Volumes of Text in a single cell

I appologise if this has been covered before, or that it is really basic. I
am new to Excel and new to this forum!!

Here it is:
After I have pasted large volumes of text (say 2 or 3 paragraphs) in to a
single cell, sometimes the final lines of the last 2 paragraphs run out of
the cell and becomes invisible. Sometimes the entire final paragraph runs
off, on one line.

I have toggled the "Wrap Text" function;
I have put the text into Word to clear formatting and/or paragraph marks to then repaste into Excel

- But I am still having problems.

The only way to get over this is to put new paragraph marks in place (using
the ALT + ENT buttons) at each point Excel causes the run off. However if I
want to resize the column for whatever reason at a later point - there are
then too many paragraph marks!!

Your help is greatly appreciated!!