Importing rows or columns with blank cells

Importing files that contain columns (for row processing mode) with blank cells, such as shown in the figure below, may result in data not importing into the correct data set.
To resolve this problem, cells that are blank should be filled with spaces. In Excel, do the following:
  1. Select columns G and I.
  2. Select
    Edit
    , then
    Replace
    .
  3. Leave the
    Find what
    field blank.
  4. Place the mouse in the
    Replace with
    field.
  5. Press the space bar once.
  6. Select
    Replace All
    .
  7. Save the file.
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close