Mac Forum / Applications / Word / February 2006

I have a double problem :

The final result is that after merging an Excel file ("database") with
a Word file, putting some of the Excel data into cells in a Word table,
some of the cells' contents are partially misaligned. I format a Word
cell to contain only one data item ("parcel_address"), normally
left-aligned, and in some cases, the inserted data from Excel is split
into 2 paragraphs, the first being left aligned with a 7,62cm
left-margin, the second part being OK (no left margin).

Why is this ?
Well, in Excel, the "parcel_address" is a concatenated string with
company, street, zip code, city and country all put together. The
glitch is with the street name, which itself comes from an internet
hosted application : I export the data (ISO Latin 1 character encoding)
and have to convert it to Mac Roman + Mac line breaks with TextWrangler
before before being able to read it correctly into Mac Excel 2004.
The result, at the end, is that the original line break in a multi-line
street name turns into a paragraph mark in Word, which misaligns the
first part of the address.

Why ?
How can I work around this problem ?

Thanks for any help,
Rup