Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't change cell content in Excel by dragging | Excel Worksheet Functions | |||
excel cell content cuts off when merged to word | Excel Discussion (Misc queries) | |||
How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
Can you reference a cell that is sorted in excel 2002? | Excel Worksheet Functions |