| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make sure all empty columns are present in a .csv file?
I am creating a .csv file to upload into another program that requires that
all columns be present in the file even if no data is entered. How do I make sure that each column is recognized on each line of the spreadsheet even if no data is entered? I do not want to manually have to insert info into a cell to insure that the upload utility acknowledges it. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make sure all empty columns are present in a .csv file?
Select the table you're importing, then go to Edit--GoTo--Blanks and enter a
value in all the highlighted blanks. -- Brevity is the soul of wit. "Decision Assist" wrote: I am creating a .csv file to upload into another program that requires that all columns be present in the file even if no data is entered. How do I make sure that each column is recognized on each line of the spreadsheet even if no data is entered? I do not want to manually have to insert info into a cell to insure that the upload utility acknowledges it. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing a particular excel worksheet into another excel file | Excel Worksheet Functions | |||
| saving .csv formated file | Excel Discussion (Misc queries) | |||
| Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Linear Mode
