Hi Harry, I think you will find the limit is 1024 chars per cell, and if I remember it's a display limit only.
>From the Excel 2002 help... Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. Note, changing the format for the cell to 'General' I think it is, can help display the cell contents that was set to 'text' ?? (something like that anyway) Darren Moore > -----Original Message----- > From: [EMAIL PROTECTED] > > > Hi Mike, > > Any version of MS Excel before version 12 has a maximum column and > cell size of 255 characters. Depending on the data, and the specific > version of Excel, anything over 255 characters will either be > truncated or ignored. > > You can see a full list of Excel limits here: > http://blogs.msdn.com/excel/archive/2005/9/26.aspx > > Regards - Harry > > > At 06:26 AM 1/14/2006, Mike Reagan wrote: > >Hi All > >I am using Altium Designer SP4. Most of our designs have some > >components which are used more than 50 times. (i.e. decoupling > >capacitors). I have generated BOMs as CSV, text, and xls > >outputs. Altium does a great job with any of these formats, however > >when we import to into MSoft Excel, fields with large amounts of > >characters such as the reference designators are omitted. The > >problem is specific to MSOFT Excel since I have used other > >spreadsheet programs like Quatro Pro. Has anyone else run > into this problem? > > > > > >Mike Reagan > >EDSI > SNIP ____________________________________________________________ You are subscribed to the PEDA discussion forum To Post messages: mailto:[email protected] Unsubscribe and Other Options: http://techservinc.com/mailman/listinfo/peda_techservinc.com Browse or Search Old Archives (2001-2004): http://www.mail-archive.com/[email protected] Browse or Search Current Archives (2004-Current): http://www.mail-archive.com/[email protected]
