excel worksheet database

[natalie]

I have a database containing addresses. In the worksheet
all is well. But when I mail merge to Word for labels, the
text is formatted strangely- there are several character
spaces between the city and state on most of the labels,
and I cannot figure out how to remove that without doing
it manually on every label. I think the problem is
originating in the worksheet formatting. Any ideas?

 

[Carl Manaster]

Hi, Natalie,

I have a database containing addresses. In the worksheet
all is well. But when I mail merge to Word for labels, the
text is formatted strangely- there are several character
spaces between the city and state on most of the labels,
and I cannot figure out how to remove that without doing
it manually on every label. I think the problem is
originating in the worksheet formatting. Any ideas?

Use the LEN function to figure out if there are in fact spaces around
the values in your spreadsheet. Use the TRIM function to trim off the
spaces if they are there.

Peace,
--Carl