Combining all rows of two colums together into one column

  • Thread starter Thread starter Jim B
  • Start date Start date
J

Jim B

I am using the CONCATENATE function to combine the data of two columns into 1
new column. I have 65,000 rows of data. How do I copy this function into each
of the 65,000 rows of my new column without having to enter the function
manually into each row? ie, =CONCATENATE(F2," ", G2) is for the first row.
I need this for each row up to =CONCATENATE(F65000," ",G65000).
 
Select the formula cell in row2. Double click the handle (right bottom) of
cell selection box. OR copy the cell>Select the cells>paste
Special>Formulas>OK

If this post helps click Yes
 
Back
Top