View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sandlapper99 sandlapper99 is offline
external usenet poster
 
Posts: 1
Default Changing commas in .csv to quotation marks

Hi-I have a 1000 record data sheet in CSV, that I am trying to import into
our line of business application. The CSV has both the field and data values
separated by commas. The LOB application requires that the data values by
separated by quotation marks or single quotation marks. Is there a way for
me to change this in the CSV file? Thanks so much for your help.