Thank you for the clarification...:-)

"Gord Dibben" wrote:

Just for info.

Most labelling programs like the data to be in separate columns, not all in
one.

i.e. if you were to use Word for making the labels with Excel as the data
source you would need the data in separate columns. Each record on its own
row.


Gord Dibben Excel MVP

On Wed, 14 Dec 2005 03:27:02 -0800, "CONCATENATE Excel function" <CONCATENATE
Excel wrote:

I cannot seem to figure out the CONCATENATE function. I have an enormous
amount of info. on a spreadsheet, from which I would like to extrapolate
information to make a address label database. How do I do this?