line break does not appear in CSV


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

Advertisements

B

Bob I

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)
 
B

BSc Chem Eng Rick

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

Advertisements

B

BFON

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top