How to concatenate vertical column in Excel into one string?

Hi,

I have an Excel sheet with one column (col A) and 100 rows. Like this,
100
101
102
103
....

I want to concatenate all the rows into one string, with the values seperated by commas. Like this,
"100,101,102,103..."

How can I do that?

Thanks.
2 answers 2