Combining 2 colums

  • Thread starter Thread starter Jeremy Schubert
  • Start date Start date
J

Jeremy Schubert

I'd like to combine the data in colum 1 with colum 2, If I use =a1&" "a2 in
colum 3, I can't delete colums 1 and 2. How can I create column 3 and be
able to delete columns 1 and 2? Thanks
 
Hi Jeremy,
You can use the Join macro, that will join selected (contiguous)
columns into the first of the selected columns so that it is all one value
per row.

Rearranging Data in Columns
http://www.mvps.org/dmcritchie/excel/join.htm

Max's reply may be a bit vague, he is suggesting
converting the columns to values thereby removing
formulas. He didn't really tell you how to then join them,
but that would have been by concatenation into a new cell.
F1: =C1 & " " & D1 & " " & E1
Use the fill-handle to copy the formula down
Then delete columns C, D, and E

Using a macro makes things a lot quicker, since you simply
select a contiguous group of columns and run the macro,
and will probably have to do this on many occasions.
 
.. Max's reply may be a bit vague
.. He didn't really tell you how to then join them,
but that would have been by concatenation into a new cell.
Click to expand...

Believe the OP already knows it (how to concatenate) as indicated in his
post, albeit he posted his sample formula with careless typos. And his sample
was also confusing in using a1 and a2 instead of a1 and b1 to illustrate,
since everywhere else he mentions "columns". My reply wasn't in any way
vague, it was incisive.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
 
.. Max's reply may be a bit vague
.. He didn't really tell you how to then join them,
but that would have been by concatenation into a new cell.
Click to expand...

Believe the OP already knows it (how to concatenate) as indicated in his
post, albeit he posted his sample formula with careless typos. And his
sample was also confusing in using a1 and a2 instead of a1 and b1 to
illustrate, since everywhere else he mentions "columns". My reply wasn't in
any way vague, it was incisive.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
 
Thank you both.
David McRitchie said:
Hi Jeremy,
You can use the Join macro, that will join selected (contiguous)
columns into the first of the selected columns so that it is all one
value
per row.
Rearranging Data in Columns
http://www.mvps.org/dmcritchie/excel/join.htm

Max's reply may be a bit vague, he is suggesting
converting the columns to values thereby removing
formulas. He didn't really tell you how to then join them,
but that would have been by concatenation into a new cell.
F1: =C1 & " " & D1 & " " & E1
Use the fill-handle to copy the formula down
Then delete columns C, D, and E

Using a macro makes things a lot quicker, since you simply
select a contiguous group of columns and run the macro,
and will probably have to do this on many occasions.
Click to expand...
 
Back
Top