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?


[TABLE="width: 131"]
<colgroup><col></colgroup><tbody>[TR]
[TD]SHARE:6037138400,[/TD]
[/TR]
[TR]
[TD]SHARE:5500360000,[/TD]
[/TR]
[TR]
[TD]SHARE:6590192700,[/TD]
[/TR]
[TR]
[TD]SHARE:6590180400,[/TD]
[/TR]
[TR]
[TD]SHARE:6037119700,[/TD]
[/TR]
[TR]
[TD]SHARE:5500502700,[/TD]
[/TR]
</tbody>[/TABLE]

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.