convert excel column data to comma seperated string

I have excel file in which data is present in a column as


234
654
222
444
667
555


I want this text in this form 234,654,222,444,667,555.I tried many ways bt unable to do so,Kindly tell me any easy way of doing this.

Formula wise it's a little convoluted unless you make use of 3rd party utilities like morefunc.xll and / or other custom UDFs of which there are plenty if you Google.

A basic example of such a UDF being:

Please Login or Register  to view this content.

With the above stored in a Module in VBE you can utilise from native XL by virtue of a "normal" function in which you simply specify the range containing the values to be concatenated and preferred delimiter, eg:

Please Login or Register  to view this content.

would concatenate all non-blanks in the range, each value being delimited by a comma.

Hi,

Another approach would be:

Please Login or Register  to view this content.

Orlando Mezquita

I should elaborate perhaps in response to above variant the reasons for the apparent complexity of the first code.

The first code is designed to limit the need for iteration as much as possible and/or dispense with it fully where possible.

The code will iterate only where range is a matrix (as opposed to a vector) and then only on a column by column basis - ie cell by cell iteration is avoided.