The simplest solution to this problem is to put an apostrophe (') - also known as a single quotation mark - in any cell in the last column (the "LM" column) that is intentionally left blank. (Tip: If the records with blank LM fields are all grouped together, you can put one apostrophe in the first row and copy it down.) This will tell Excel to fill in the comma to indicate a blank item at the end. (Note that you will not be able to see the apostrophe in the worksheet but if you go to the cell, you can see it in the formula editing bar.) STN Support can provide additional assistance if you intend to prepare your data file in Excel. |