How do I merge the contents of two columns?

A

adamnabors

I have two columns of text (thousands of rows) that I would like to be in one
column. Ex.: 4568-15-651 and FR to 4568-15-651FR. I have done this before
i just can't remember how. Help.
 
P

Peo Sjoblom

You need to use a third column

=A1&B1

copy down and the copy and paste special as values in place
If you want a space between the values

=A1&" "&B1

a comma and a space

=A1&", "&B1



Regards,

Peo Sjoblom
 
Top