Line break in Excel cell, merged into a cell in a Word document
- From: rgbarrow@xxxxxxxx
- Date: 10 Feb 2006 15:39:54 -0800
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
.
- Follow-Ups:
- Re: Line break in Excel cell, merged into a cell in a Word document
- From: John McGhie [MVP - Word and Word Macintosh]
- Re: Line break in Excel cell, merged into a cell in a Word document
- Prev by Date: Trouble With Table Borders in Page Breaks
- Next by Date: Re: Trouble With Table Borders in Page Breaks
- Previous by thread: Trouble With Table Borders in Page Breaks
- Next by thread: Re: Line break in Excel cell, merged into a cell in a Word document
- Index(es):
Relevant Pages
|
