Concatenate question

[goodmachine]

Hello,

I would like to concatenate data in Column C (see below) into a single string of text. So, for the data below, I want to read like the following:

SHARE:6037138400,SHARE:5500360000,SHARE:6590192700,SHARE:6590180400,SHARE:6037119700,

I have over 300 values in the column, so I don't want to have enter each cell manually into the formula. I can tell the formula to concatenate all the values from the column?

SHARE:6037138400,

SHARE:5500360000,

SHARE:6590192700,

SHARE:6590180400,

SHARE:6037119700,

SHARE:5500502700,

<colgroup><col></colgroup><tbody>
</tbody>

Thank you,
goodmachin

 

[West Man]

One way:
In an empty column (assume D), in cell D3 enter =C2&C3
In d4 =D3&C4
Drag this formula down to the end of your data

 

[goodmachine]

Thank you West Man. Your solution worked great. I appreciate the help.

One way:
In an empty column (assume D), in cell D3 enter =C2&C3
In d4 =D3&C4
Drag this formula down to the end of your data

 

[West Man]

Glad to be of assistance. Thanks for the feedback.