Jun 8, 2002 #1 Fatih235 MIS May 30, 2002 19 US Hi ; I have 2 columns like these. a e b f c g d h and i would like to create a column like these a,e b,f c,g d,h Suggestions please.
Hi ; I have 2 columns like these. a e b f c g d h and i would like to create a column like these a,e b,f c,g d,h Suggestions please.
Jun 8, 2002 #2 chogben Programmer Apr 5, 2002 73 GB One way to do this is to use a formula to create a entry in a third column =A1 & "," & B1 Copy the formula into the cells and copy them into the same range using paste special - selecting values. or just leave the formula in place if you don't intend to delete the original columns. Upvote 0 Downvote
One way to do this is to use a formula to create a entry in a third column =A1 & "," & B1 Copy the formula into the cells and copy them into the same range using paste special - selecting values. or just leave the formula in place if you don't intend to delete the original columns.