Problems with Cell Data Merging
PDF2XL Support avatar
Written by PDF2XL Support
Updated over a week ago

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:

A. Go into your Options and remove the checkmark from "Merge cells with overflowing text", then try moving the column divider to see if you can find the exact point where the two columns separate.

B. Go into your Options and set the "Space-to-letter ratio".

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

Did this answer your question?