Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating a master file | Excel Worksheet Functions | |||
Creating automatic log file | Excel Discussion (Misc queries) | |||
Creating % formula help for log file. | Excel Discussion (Misc queries) | |||
Creating a CSV File from.... | Excel Discussion (Misc queries) | |||
creating a file name from a cell | Excel Discussion (Misc queries) |