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!

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!

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!