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!!
|