excel worksheet database

  • Thread starter Thread starter natalie
  • Start date Start date
N

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?
 
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?
Click to expand...

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
 
Back
Top