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


"Mr. Low" wrote:

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

--
A36B58K641