Excel truncating imported file to 256 characters per cell - Help


D

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]>
 
Ad

Advertisements

B

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
 
Ad

Advertisements

D

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]>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top