I have a spreadsheet that has property address numbers in one column and the
street names in another column. In order for me to use my mailing system I
need to have the address # and street names as a single field. I have 5000
rows of data. Is there a way to automate this? Similar to the Text to Columns
function but in reverse.

Thanks for you help.

Exactly the reverse of Text to Columns...

Say the address numbers are in column A and the street names are in column
B. Then in column C put =A1&B1 and copy down. If you need a single space
between the two, use =A1&" "&B1
--
Gary''s Student


"rt10516" wrote:

I have a spreadsheet that has property address numbers in one column and the
street names in another column. In order for me to use my mailing system I
need to have the address # and street names as a single field. I have 5000
rows of data. Is there a way to automate this? Similar to the Text to Columns
function but in reverse.

Thanks for you help.

thanks. that worked great!!

"Gary''s Student" wrote:

Exactly the reverse of Text to Columns...

Say the address numbers are in column A and the street names are in column
B. Then in column C put =A1&B1 and copy down. If you need a single space
between the two, use =A1&" "&B1
--
Gary''s Student


"rt10516" wrote:

I have a spreadsheet that has property address numbers in one column and the
street names in another column. In order for me to use my mailing system I
need to have the address # and street names as a single field. I have 5000
rows of data. Is there a way to automate this? Similar to the Text to Columns
function but in reverse.

Thanks for you help.