Excel truncating imported file to 256 characters per cell - Help

[Don Strachan]

Hi to all

I am trying to import a works database into excel.

I can convert database to CSV etc but on importing to or opening in
excel the text in each cell is truncated to 256 characters.

If I paste 1 cell from Excel into say Word I only get 256 characters.

I have researched this on the internet but cannot find the answer.

I can paste and invidual cell from Works to Excell and the text is not
truncated and can all be seen.

I cannot bulk paste them without them being truncated

What is is the solution?
Database is about 300,000 cells

I am using Excel from Office 97


Cheers
Don Strachan

For some 10,000 NZ and international Automotive, Alternate Fuel and Motorsport Links and information.

Dons Auto Pages: <http://www.donsautopages.co.nz/>
Email: <[email protected]>

 

[Bernard Liengme]

From Excel Help when I searched "specs":
Column width 255 characters
Row height 409 points
Page breaks 1000 horizontal and vertical
Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


Try this:
Make cell width about 1/2 screen width
Use Format |Cells; open Alignment tab and check Wrap Text

I was able to see 1024 characters and copy them to Word
(I work with Excel 2003 & Word 2003)
best wishes

 

[Don Strachan]

Hi Bernard

Thanks very much

I can't believe its that simple Or am so Dumb

Many thanks

From Excel Help when I searched "specs":
Column width 255 characters
Row height 409 points
Page breaks 1000 horizontal and vertical
Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


Try this:
Make cell width about 1/2 screen width
Use Format |Cells; open Alignment tab and check Wrap Text

I was able to see 1024 characters and copy them to Word
(I work with Excel 2003 & Word 2003)
best wishes

Cheers
Don Strachan

For some 10,000 NZ and international Automotive, Alternate Fuel and Motorsport Links and information.

Dons Auto Pages: <http://www.donsautopages.co.nz/>
Email: <[email protected]>