Beth

Only you can tell whether or not the text is a result of a formula.

What do you see in the Formula Bar.

Text or Formula?

If a formula, convert to a value by copypaste specialvaluesokesc


Gord Dibben MS Excel MVP

On Wed, 14 Feb 2007 11:03:12 -0800, BethB
wrote:

Thanks for responding, but that did not seem to help.
Is it perhaps that this is a formula and not straight text? - I cannot seem
to get it to recognize the hard return.

Beth

"Gary''s Student" wrote:

Put an occasional hard-return in the cell along with the text.

The hard-retrun is ALT-ENTER
--
Gary''s Student
gsnu200706


"BethB" wrote:

I have a cell where I have concatenated 2 cells with very long paragraphs in
each. These 2 cells were made up of concatenations of other cells and were
split since Excel indicates that the original formulas were too long. The
problem is that the value in the cell does not completely show and there is
still white space at the bottom of the cell. If I change the column width,
the amount of text that shows changes somewhat, but still never shows it all.
I have copied and pasted the value of the cell into Word and the entire
contents are there.

Does anyone know how I might get this data to show?

Thanks in Advance
Beth