Merging two columns of data

  • Thread starter Thread starter JustMe602
  • Start date Start date
J

JustMe602

I have 2 columns of data.

I would like to merge the contents but I don't want to erase any of th
data in either one of them.

Can I do this easily?


Thanks.
JustMe
 
use a helper column.

assuming you want to merge a1 with b1 (and a space in the middle), use the
following formula.

=A1&" "&B1
or
=concatenate(a1," ",b1)
 
Assuming your data is in A:A and B:B. In cell C1,

=CONCATENATE(A1,B1)

Copy down the column.

Cheers,

Stev
 
Is there a way to actually move the data without a formula...

Cause I want later to seperate them out again.

Client City, State ZIP From MAITLAND F L 3XXX1 To
IRVINE CA 9XXX2
Client Business phone From 555-XXX-XX4 0 To
999-XXX-0XX1
Client Fax Number From 555-XXX-XX3 0 To
999-XXX-0XX6
Client Address line 0 From C/O CLIENT N AME To
INTERNATIONAL


So what I need to do is pull the information back together then put the
from in one column and the to in another column. As well as the first
part the identifier of the information.
 

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

Merging multiple columns into one column (dynamically) 1
Merge Columns 3
Merging data from 2 data excel sheets 2
sorting two columns of merged cells 1
VBA set thick borders around non empty cells in range 0
Line Up Two Columns In Excel 2
Sharing workbooks limitations - Merged Cells 12
How to merge two columns of data 4

Back
Top