Force Excel Import Wizard to Use Character for All Columns?
I am trying to import several one sheet from several auto-generated Excel tables and then concatenate into a larger file. The problem is that the first row contains the 'blank' data which has no batch/lot/etc. info, and the Excel cells have 'general' as the format. The next three columns are empty for the 'blank' but full for all other rows (samples). The first (batch) always imports correctly ...
