Skip to main content

Problems with Cell Data Merging

How to fix data that merges together due to overlapping columns

Team PDF2XL avatar
Written by Team PDF2XL
Updated over 2 months 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. You may need to move the divider so that it sits directly on a character.


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

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

Did this answer your question?