How do I merge the contents of two columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find by first two characters 2
Merging multiple columns into one column (dynamically) 1
counting blank cells within two columns 2
sorting two columns of merged cells 1
Changing the number of columns within existing column(s) 1
Macro to add numbers in a text string 5
Merge Columns 3
Leading Zeros 2

Back
Top