Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to combine data from two different cells. I understand that I can
do the Concatenate formula, but I need to do it to the entire column. For example: ws 100 ws 200 ws 300 I know how to combine the A and B cells to be together but is there a way to do both columns all at once (to be put in a new column). I have a document with over 1400 items and I am really hoping that I wont have to individually concatenate them! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Wouldn't simply replicating the formula from say cell c1 down through cell
c1400 work. OR do you mean that you want a new cell that contains the values from all 1400 "a" cells added to all 1400 "b" cells? "Sarah85" wrote: I am trying to combine data from two different cells. I understand that I can do the Concatenate formula, but I need to do it to the entire column. For example: ws 100 ws 200 ws 300 I know how to combine the A and B cells to be together but is there a way to do both columns all at once (to be put in a new column). I have a document with over 1400 items and I am really hoping that I wont have to individually concatenate them! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes!!! That was exactly what I needed! Thank you so much, I think my mind
thought it had to be more complicated then it was! That was just too easy, I REALLY appreciate your help (and mind!) THANK YOU "JR Hester" wrote: Wouldn't simply replicating the formula from say cell c1 down through cell c1400 work. OR do you mean that you want a new cell that contains the values from all 1400 "a" cells added to all 1400 "b" cells? "Sarah85" wrote: I am trying to combine data from two different cells. I understand that I can do the Concatenate formula, but I need to do it to the entire column. For example: ws 100 ws 200 ws 300 I know how to combine the A and B cells to be together but is there a way to do both columns all at once (to be put in a new column). I have a document with over 1400 items and I am really hoping that I wont have to individually concatenate them! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
COMBINING CELLS WITH LIKE DATA | Excel Discussion (Misc queries) | |||
combining partial data from 2 different cells | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |