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?).
Bookmarks