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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

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".
 

Forum statistics

Threads
1,176,401
Messages
5,902,840
Members
435,000
Latest member
jmc12

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