Thread: Excel 2002: Merging cell content with a comma seperattor
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Low Mr. Low is offline
external usenet poster
  
Posts: 505
Default 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
Reply With QuoteReply With Quote