Merging two columns of data

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
 
J

Jonathan Cooper

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)
 
S

SteveG

Assuming your data is in A:A and B:B. In cell C1,

=CONCATENATE(A1,B1)

Copy down the column.

Cheers,

Stev
 
J

JustMe602

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