Assuming cells are in column A

In B1 enter =LEN(A1) and double-click fill handle to copy down.

Autofilter on column B for customgreater than 1000


Gord

On Mon, 15 Dec 2008 11:44:09 -0800, suestew
wrote:

Thanks - your response was very helpful. I do have more than 1024 characters
in many of the cells. Now the question is, can I filter cells that have that
or more so I can adjust those by group rather than individually.

Thanks.

"Gord Dibben" wrote:

How much text is not showing up?

If you have more than 1024 characters in a cell Excel will display only the
first 1024.

Add an Alt + Enter every 80-100 chars.

Another thing..............if cells are merged, autofit will not work.

You would need event code to autofit any row with merged cells.


Gord Dibben MS Excel MVP

On Mon, 15 Dec 2008 09:55:01 -0800, suestew
wrote:

So I've used "wrap text" and I've used "Row - auto fit" and I still have text
that is not showing up in the cell. I have 2800 lines and I'm going to have
to go through individually and make sure they are all the right height.
There has to be a simpler way.

Please help. I'm desperate.

Thanks.