View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default Combining Data: 2 Different Cells, Doing the Whole Column @ Same T

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!