Combining all rows of two colums together into one column

[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).

 

[Jacob Skaria]

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