Merging

[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???

 

[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

 

[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




.