Creating Delimited List

[Riviera*]

How do I create a list of numbers delimited by a coma from a column of data from an excel spreadsheet. Each number is in a separate cell.

Thanks

 

[Mark W.]

Save the worksheet as .csv.

 

[Mark W.]

Or, perhaps you mean...

Book1
	A	B	C	D	E	F	G	H	I
1	1	2	3	4	10	233
2
3	1,2,3,4,10,233
4
5
6
Sheet5

Note: MCONCAT is supplied by the Morefunc add-in.

 

[Riviera*]

Looks like this:-

2342343242
2342334244
2324234242
4354354353
3453453453

Want it to look like 33324243435,43534534534543,345345345345,34534534,345345345

in notepad.

Thanks.

Riv

 

[Mark W.]

Not quite sure how you got your results Mine are...

Book1
	A	B	C	D	E	F	G	H
1	2342343242
2	2342334244
3	2324234242
4	4354354353
5	3453453453
6
7	2342343242,2342334244,2324234242,4354354353,3453453453
8
9
10
Sheet4