ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Showing the entire text within a cell. (https://www.excelbanter.com/excel-worksheet-functions/237467-showing-entire-text-within-cell.html)

lehigh46

Showing the entire text within a cell.
 
Hi ALL,

I copied and pasted about 600 items from a CSV file into a blank Excel
sheet Ver 2007.
Aprox 10 % of the cells did NOT show all of the text.
I formatted all cells for word wrap & auto fit row height but it just
doesn't work for some of the cells.
What could be the problem?

Thanks for your help.
Tom

Bam

Showing the entire text within a cell.
 
If it's a CSV file, why don't you open it with excel and let it do the work.
Else, try Import text file.

Bam.

"lehigh46" wrote:

Hi ALL,

I copied and pasted about 600 items from a CSV file into a blank Excel
sheet Ver 2007.
Aprox 10 % of the cells did NOT show all of the text.
I formatted all cells for word wrap & auto fit row height but it just
doesn't work for some of the cells.
What could be the problem?

Thanks for your help.
Tom



All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com