Merging

J

John

I am trying to merge 3 colums with info in each colum.
How do I do it without loosing the info in the 2 to the
right???
 
P

Peo Sjoblom

Use a help column and concatenate the values,
assume they are A, B and C, in D use something like
this

=A2&" "&B2&" "&C2

copy down as long as needed, copy and paste special as values
in place. Delete the old columns
 
J

john

Thank You for the advice, it worked fine.
-----Original Message-----
Use a help column and concatenate the values,
assume they are A, B and C, in D use something like
this

=A2&" "&B2&" "&C2

copy down as long as needed, copy and paste special as values
in place. Delete the old columns

--

Regards,

Peo Sjoblom




.
Click to expand...
 
Top