Importing data to excel (newline/carriage return issue)
Hi, Chris-
As an idea, can you lash together a script of one type or another
(perl?) that reads the file and strips out the linefeed (or whatever is
causing Excel to interpret a new row), and replaces it with a carriage
return? Sounds like you should then be able to import to excel with no
worries.
Dave O
|