two column merge

kelleyl

New Member
Joined
Jul 22, 2010
Messages
6
I have a excel file 4800 rows of data. I need to merge two columns of data into a one, or at least a new column.

I know how to do the formula to merge cells just can't figure out how to do complete columns. and don't want to do (=A1&", "&B1) 4000 times. :(

By the way I am working on a Excel for Mac it that makes a difference.

Thanks for the help,

Kelley
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

rallcorn

Well-known Member
Joined
Nov 11, 2008
Messages
1,027
Enter your formula at top copy your formula down to all rows in same column
 

mvptomlinson

Well-known Member
Joined
Mar 10, 2008
Messages
2,638
In the first row (let's say row 1) enter

=A1&", "&B1

Assuming you have a list of data in columns A and B with no empty cells, and your concatenation formula is in C1, then hover over the lower right corner of C1 and double-click once you see the cursor change to a cross (or plus sign).

If there are gaps in your data, or you're formula is not immediately next to the two columns of data, rather than double-clicking the cross, click and hold the mouse button down, then drag your mouse downward until you reach the bottom of your data or include as many rows as is in your original data.

It's called "filling down".
 

Watch MrExcel Video

Forum statistics

Threads
1,133,378
Messages
5,658,465
Members
418,446
Latest member
JValencia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top