| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
line break does not appear in CSV
The "line breaks" will be characters in line with the rest of the
printable characters in Notepad. If you want to see the "effects" open the csv file with WordPad or edit.com(You should edit.com in Windows\System32 folder) BFON wrote: I am formatting text in a cell, and inserting line breaks with CHAR(10) and &. Text in the cell correctly appears with line breaks inserted, when viewed in Excel. I then save the file as a CSV and view that file in Notepad. No line breaks are seen in the CSV. Also tried the " <ALT<ENTER " method with no success. Using Excel 2007. Viewing CSV in Notepad, with Word Wrap turned off. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a line break to always work? | Excel Discussion (Misc queries) | |||
| Line break | Excel Discussion (Misc queries) | |||
| ALT+ENTER = line break | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Line Break | Excel Discussion (Misc queries) | |||
Threaded Mode
