Under Insert select Function, select all for the
category. Select the Concatenate function. Then put the
columns in each of the text fields that come up in the
wizard.

So in column D it will read
=CONCATENATE(A1, B1, C1)
Copy this function to each row.

-----Original Message-----
I have a mailing list that has the street number (column
A), street name
(column B), and street suffix (column C) in separate
columns on each row
(1037 rows). I would like to combine the data on each
row of these 3 columns
into only one column. I have tried every thing I could
find in the help
files, thanks,
Bill
.