How to convert rows of Excel addresses into a single column in Word?

exceltm

New Member
Joined
Apr 5, 2010
Messages
32
This is what I have in Excel, rows of addresses:

John Doe | 123 Anystreet | Anytown, NY 12345
Mary Doe | 123 Anystreet | Nowhere, NY 22333

This is how I want it to appear in Word, a single column of addresses:

John Doe
123 Anystreet
Anytown, NY 12345

Mary Doe
123 Anystreet
Nowhere, NY 22333

How do I convert them?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
Use Mail Merge in Word to do this for you and just select the fields and place them as an address line.
 

exceltm

New Member
Joined
Apr 5, 2010
Messages
32
Use Mail Merge in Word to do this for you and just select the fields and place them as an address line.

I need more help or clarity, please

Yes, this works, but not how I want it to work. It puts 1 address on each page, and puts double-spaces between each line of the address.

I don't want this for letters with only 1 address per page. I want it for all the addresses in a single column.
 

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
You have to map the fields. Which version of MS Office are you using? Do you need all the addresses on a single page or single page per address?
 

exceltm

New Member
Joined
Apr 5, 2010
Messages
32
I wanted them to be in a single column, with a blank line in between each set. I figured it out. Simply use this "code" in MS Word Mail Merge, then copy it down the page, but with each new record beginning with the Next Record tag. Thanks for your advice.
«name»
«address»
«city» «state» «zip»
«phone»
«hours»
«Next Record»
«name»
«address»
«city» «state» «zip»
«phone»
«hours»
«Next Record»
«name»
«address»
«city» «state» «zip»
«phone»
«hours»
 

Watch MrExcel Video

Forum statistics

Threads
1,123,017
Messages
5,599,359
Members
414,306
Latest member
Dennis_vdw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top