Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging with Excel which has line feeds
I have an Excel spreadsheet which has some fields with multiple lines within
the cell. When merging to Word, the line feeds are replaced with a block character that I can't seem to search on (to replace) - I've tried to copy it but it does not copy. Is there a way - either in Excel, as part of the merge form, or after it's merged - to get this to show up as a line feed? I'm using Word and Excel 2002. TIA, Mike |
#2
|
|||
|
|||
Okay - I just answered my own question . If I insert the address fields
individually (instead of using the address block), it merges correctly. Mike "Mike" wrote in message ... I have an Excel spreadsheet which has some fields with multiple lines within the cell. When merging to Word, the line feeds are replaced with a block character that I can't seem to search on (to replace) - I've tried to copy it but it does not copy. Is there a way - either in Excel, as part of the merge form, or after it's merged - to get this to show up as a line feed? I'm using Word and Excel 2002. TIA, Mike |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format merging to Word XP version | Mailmerge | |||
Merging from Excel into word | Mailmerge | |||
How do you keep the currency format when merging data from Excel? | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge | |||
formatting links from excel into word (extra line feeds) | Microsoft Word Help |