Combining single rows into multiple lined items

I have an Excel 2003 spreadsheet containing several thousand rows of data which looks like the attached image.

The goal is to print out these addresses on Avery 1 x 4" labels using an Avery template with Word 2003.

The end result for each address would look like this:

FIRST NAME LAST NAME
ADDRESS LINE 1
ADDRESS LINE 2 (if any)
CITY, STATE, ZIP

My first idea was to concatenate the data together in another cell and running through all of the cells this way.


I was trying something like this:

=CONCATENATE(A1,CHAR(32),B1,CHAR(13),C1,CHAR(13),D1,CHAR(13))

But it didn't work - the CHAR(13) space character does not work and the formula seemed to break.

Can anyone think of a clever way to do this? I have a rudimentary knowledge of VBA and I'll welcome any ideas.

Also, I guess when I'm done formatting everything in Excel I can just copy and paste the entire new concatenated column into Word (right?).