Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there. In searching for 1024 I found a lot of comments mentioning that
Excel has a cell limitation of 1024 characters. What I'm running into is that when performing an export from Excel into a delimited text file (csv) that it has a 1024 characters per line limitation as well. Some of the files I'm dealing with have lines of data (sheet has 40 columns) that have more than this many characters, which causes it to wrap, which causes my import of the data to then fail, as it's not ending/starting as I expected. Is there any way around this export line limit? I've tested it on MSExcel 2000, 2003, and 2007 and always gotten the same result. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workaround for HYPERLINK argument length limit | Excel Worksheet Functions | |||
Error message is Character Limit is over 1024 characters | Excel Discussion (Misc queries) | |||
Anyone notice excel search within cell limited to first 1024 chars | Excel Discussion (Misc queries) | |||
Display text 1024 characters in a cell | Excel Worksheet Functions | |||
Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) |