Help! Complete text in cell not showing
 

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

Help! Complete text in cell not showing
 

Unfortunately, until the new Excel comes out, the 'visible' limit in a cell
is 1024 characters. The new Excel will, reportedly, show a million
characters.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Shelley APG" wrote:

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

Help! Complete text in cell not showing
 

If you add alt-enters to force a new line within the cell every 80-100
characters, you can see way more than the documented 1000 characters.

Shelley APG wrote:

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

--

Dave Peterson

Help! Complete text in cell not showing
 

Thank You So much for your responses!

I can not tell you how much time I waisted on that one!

Hope to see the new excel version soon!

"Dave Peterson" wrote:

If you add alt-enters to force a new line within the cell every 80-100
characters, you can see way more than the documented 1000 characters.

Shelley APG wrote:

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

--

Dave Peterson

Help! Complete text in cell not showing
 

Ok, one more quick question.... will this effect saving as a CSV file and
importing it into a different program? Will all text go through regardless of
what is visible? Thank You!!!!

"Shelley APG" wrote:

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

Help! Complete text in cell not showing
 

I would try it and see how that other program imports it.

Shelley APG wrote:

Ok, one more quick question.... will this effect saving as a CSV file and
importing it into a different program? Will all text go through regardless of
what is visible? Thank You!!!!

"Shelley APG" wrote:

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!

--

Dave Peterson