Excel 2002: Merging cell content with a comma seperattor

[Guest]

Dear Sir,

May I know how to merge reference numbers in different cells to a single
cell with a comma seperator between each of them ?

Lets consider the following worksheet exampole:

Before merging

A B C D E F
1 PL12 PL13 PL14 PL15 PL16 PL17
2


After Merging

A
1 PL12,PL13,PL14,PL15,PL16,PL17
2



Thanks

Low

 

[Guest]

Try this:
=CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1,",",F1)

 

[Guest]

DEar Madam,

It works, but entering the formula for lage number of cell reference is
tedious, is there any easy way of doing it ?

Thanks

Low