Excel 2002: Merging cell content with a comma seperattor
 

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

Excel 2002: Merging cell content with a comma seperattor
 

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

Excel 2002: Merging cell content with a comma seperattor
 

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


--
A36B58K641


"Teethless mama" wrote:

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