Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 -Merging cells contents in with a comma seperator
Dear Sir,
May I know how to merge reference number in different cell to a single cell with a comma between them ? Before merging A B C D E F 1 PL12 PL13 PL14 PL15 PL16 PL17 After merging A 1 PL12,PL13,PL14,PL15,PL16,PL17 Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 -Merging cells contents in with a comma seperator
=A1&","&B1&","&.. etc
-- Kind regards, Niek Otten Microsoft MVP - Excel "Mr. Low" wrote in message ... | Dear Sir, | | May I know how to merge reference number in different cell to a single cell | with a comma between them ? | | Before merging | A B C D E F | 1 PL12 PL13 PL14 PL15 PL16 PL17 | | | After merging | A | 1 PL12,PL13,PL14,PL15,PL16,PL17 | | | Thanks | | Low | -- | A36B58K641 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 -Merging cells contents in with a comma seperator
Or you could use this UDF
Function Jon3(RngJ As Range) As String Dim i As Long, c As Range For Each c In RngJ.Cells If c < "" Then Jon3 = Jon3 & "," & c.Value Next c Jon3 = Mid(Jon3, 2, Len(Jon3)) End Function Regards Robert McCurdy "Mr. Low" wrote in message ... Dear Sir, May I know how to merge reference number in different cell to a single cell with a comma between them ? Before merging A B C D E F 1 PL12 PL13 PL14 PL15 PL16 PL17 After merging A 1 PL12,PL13,PL14,PL15,PL16,PL17 Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to let excel cells width fixed and automatically wrap the contents | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I create custom fill colors (for cells) in Excel 2002? | Excel Discussion (Misc queries) | |||
Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions |