Thread: .CSV Files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roman Roman is offline
external usenet poster
 
Posts: 3
Default .CSV Files

My csv file is delimited by commas and text is delimited by ". My file
considers carriage returns and next line characters enclosed in " as
text. I am facing a problem when trying to open this file in excel.
The excel doesn't care that next line character enclosed by " and
thinks it is the end of a record. Is there a way to excel that
anything inside " should be treated as text?

Thanks in advance