Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining all rows of two colums together into one column
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). -- Jim B |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining all rows of two colums together into one column
Select the formula cell in row2. Double click the handle (right bottom) of
cell selection box. OR copy the cellSelect the cellspaste SpecialFormulasOK If this post helps click Yes --------------- Jacob Skaria "Jim B" wrote: 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). -- Jim B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Colums | Excel Discussion (Misc queries) | |||
combining data from different rows into 1 column | Excel Discussion (Misc queries) | |||
how to leave column 1 and move all other colums up or down rows. | Excel Discussion (Misc queries) | |||
Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
Combining workshhets with different number of colums and column wi | Excel Discussion (Misc queries) |