combined contents in two different columns

R

rt10516

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.
 
G

Gary''s Student

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
 
R

rt10516

thanks. that worked great!!

Gary''s Student said:
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
Click to expand...
 
Top