CSV c/r l/f displays as box

A

Al

I have a csv created from external application. When opened and saved as
..xls the c/r within each cell display and print as a box. I am guessing it
differs from the excel alt return, which does not display. Is there a way
to replace the erroneous char so a box is not displayed?
 
D

Dave Peterson

Since you're creating the .CSV file, it might be easiest to replace the c/r with
an unused character (maybe |).

Then you could import your file and select all the cells and do:
edit|Replace
what: |
with: ctrl-j
replace all

===
If you used the alt-enter (aka Line Feed) character (char(10)) in your .CSV
file, you may be able to just try selecting the cells:

Format|cells|alignment tab|check wrap text

If you used the carriage control (char(13)), then I think your csv file would
have been imported kind of wierd. Excel would see multiple lines.

======
Chip Pearson has a very nice addin that will help determine what that
character(s) is:
http://www.cpearson.com/excel/CellView.htm
 
Top