View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Julie Julie is offline
external usenet poster
 
Posts: 150
Default creating csv file

I have an xls spreadsheet with 20 columns of data that I need to convert to a
csv file to transmit to our customer on a regular basis. Everything is
working except for one column where they tell me I must have 17 digits. In
some cases I have no data for those cells and I am supposed to include 17
blanks between the commas in the final csv file where I have no data. In
other cases I have 11 digits and will need to add 6 spaces to end up with 17.

Is there a way to set up my Excel file so that those spaces end up between
the columns in my final csv file?