View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 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