| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 stripping out line feeds
I have a tab delimited text file that I am opening with Excel. The text file
has embeded linefeeds/chr(10) in the following format char(34) & text & chr(10) & text & chr(34) & chr(9) & char(34) & text & chr(10) & text & chr(34) This should allow multiple lines of text into a single cell with cells delimted by tabs. This worked in excel 2003 until we updated office with the latest service pack and patches. Now, Excel strips out the linefeed character and places the text into a new row. This behavior can alo be duplicated in Excel. Open a new workbook. Click into a cell and type some text. Enter Alt-enter and enter more text. Save AS a text file. Open in Notepad and you will see the Quotes and chr(10). Reopen in excel and it has stripped out the linefeeds again Does anyone know how I can resolve this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| pull rss feeds into excel | Excel Programming | |||
| RTD feeds into excel not trigering a worksheet change macro | Excel Programming | |||
| Can Excel 2002 SP3 automatically import RSS data feeds? | Excel Discussion (Misc queries) | |||
| Inserting carriage returns or line feeds into data destined for MS Word. | Excel Programming | |||
Threaded Mode
