Problems with Cell Data Merging

You may find that when you create your layout, some of your columns appear to be merging the data together. There are a couple of reasons why this might happen:

1. The data in the cells is too close together
2. There is data that overlaps an adjacent cell (usually caused in the initial creation of the table in a program like Excel)
3. Text is embedded

To correct the problem, you can try one of the following options:

1. Go into your Options and remove the checkmark from "Merge cells with overflowing text", then try moving the slider to see if you can find the exact point where the two columns separate.
   
2. Go into your Options and set the "Space-to-letter ratio".

   

3. If you are running editions OCR or Enterprise, try turning on the OCR engine.