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!