line break does not appear in CSV

  • Thread starter Thread starter BFON
  • Start date Start date
B

BFON

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.
 
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)
 
Hi,

I think instead of "Line Feed" or Char(10) you need to be using "Carriage
Return" or Char(13). Try it out, let me know if it solves your problem.
 
Rick,
I solved this issue. The culprit was Notepad! Instead I viewed the file
using the better performing TextPad and it appeared correctly. I couldn't
believe it. Wasted a few hours on that one... Carriage return also works.
Regards,
-Bill
 
Back
Top