J John Sep 10, 2003 #1 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???
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 Sep 10, 2003 #2 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
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 Sep 10, 2003 #3 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...
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...
