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

"BSc Chem Eng Rick" wrote:

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.
--
If this helps, please click "Yes"
<<<<<<<<<<<


"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.