Prev: copying groups with formulas
Next: Multiple Worksheets
From: BFON on 29 Apr 2010 10:04
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.
From: Bob I on 29 Apr 2010 10:59
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.

From: BSc Chem Eng Rick on 29 Apr 2010 11:10
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.
From: BFON on 29 Apr 2010 11:23
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.
 | 
Pages: 1
Prev: copying groups with formulas
Next: Multiple Worksheets