While Excel and other popular spreadsheet programs allow users to merge cells Venzee cannot import values from merged cells:
If your spreadsheet contains any merged cells the row containing the merged cells will be skipped and those products will not be imported.
The following information will help you find merged cells and un-merge them.
To find merged cells in Excel 2016 and 2013
1. Click Home > Find & Select > Find
2. Click Options > Format
3. Select the Alignment tab and under Text control check the Merge cells box and click OK.
You have the option of clicking Find Next to find the next merged cell or clicking Find All to see all the merged cells in your spreadsheet.
Clicking an item in the list selects it in your spreadsheet.
To unmerge cells in Excel 2016 and 2013
1. Select the cell that you want to unmerge.
2. Click Home > Merge and Center
The contents of the merged cell will be moved to the upper-left cell.