View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vijay Kotian Vijay Kotian is offline
external usenet poster
 
Posts: 75
Default Convertion of excel to CSV format

While saving excel file to CSV format the fields which are blank are
seperated with comma or in one of the row have more number of columns then
all the rows picks up the highest number of columns and the file saved with
CSV format gives us with unnecessary comma's - how to save CSV file without
these extra comma's OR Excess comma's should not be created ?