Export addresses from Word to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I export addresses from Word to Excel so that the address lines stay in one cell

Thanks, Benedict
 
Dave Peterson posted the following advice to a similar question:

'==========================================
I do this:

Inside Word, select the table and do two Edit|Replaces.
First one replaces paragraph mark (^p) with a unique string ($$$)
second one replaces manual line break (^l) (lowercase ELL) with $$$

Then copy the table and paste into Excel.

then do an Edit|Replace within excel.
Replace $$$
with hit and hold the alt-key and type 0010 from the number pad
(It may look like nothing was entered, but try it.)

alt-0010 is the same as the alt-enter to wrap to a new line in an excel
cell.

Don't forget to close the word document without saving.
'===========================================
 
Back
Top