Reply
 
Thread Tools Display Modes
  #1   Report Post  
Mike
 
Posts: n/a
Default 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   Report Post  
Mike
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date format merging to Word XP version Linda - Xtremly Peeved Mailmerge 11 April 12th 05 06:50 AM
Merging from Excel into word Wim Willemse Mailmerge 3 March 31st 05 12:17 PM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 06:33 PM
Format Excel data for merging in Word BW Mailmerge 1 January 21st 05 01:25 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 04:13 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"