L
Liz-ac
I am doing a merge in word using excel data. The spreadsheet has
numerous columns which are being pulled to the merge. The first column
can contain a name and the second can contain a number. All further
columns follow that same pattern. I have some blank fields in excel
in all columns and do not want them to print on the merged document.
It is not printing the fields that are blank in the name columns but is
printing a 0 in the number columns that are actually blank in excel.
Is there a way around this?? (I've already tried formatting the excel
columns as text and general)
For example:
smith 3
(blank line)
jones 4
white 5
(blank line)
Word merges as follows:
smith 3
jones 0
white 4
5
0
HELP!
numerous columns which are being pulled to the merge. The first column
can contain a name and the second can contain a number. All further
columns follow that same pattern. I have some blank fields in excel
in all columns and do not want them to print on the merged document.
It is not printing the fields that are blank in the name columns but is
printing a 0 in the number columns that are actually blank in excel.
Is there a way around this?? (I've already tried formatting the excel
columns as text and general)
For example:
smith 3
(blank line)
jones 4
white 5
(blank line)
Word merges as follows:
smith 3
jones 0
white 4
5
0
HELP!