Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with the formula
I have few serial numbers where in I need to connet for some of the line
items I have in my spreadsheet. For Eg: If I have 123 as serial numbers and I have 3 items to connect. Three items are a.5685 b. 9000 c. abcd. The result should come as Serial# Line item 123 5685 123 9000 123 abcd This is how it should look. I have nearly 6000 line to do like this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with the formula
One guess ..
I'll presume this is your source table (not the result <g): Serial# Line item 123 5685 123 9000 123 abcd Place in C2: =A2&"-"&B2 Copy C2 down. Replace the dash: "-" in the formula with your desired separator -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Igneshwara reddy" wrote: I have few serial numbers where in I need to connet for some of the line items I have in my spreadsheet. For Eg: If I have 123 as serial numbers and I have 3 items to connect. Three items are a.5685 b. 9000 c. abcd. The result should come as Serial# Line item 123 5685 123 9000 123 abcd This is how it should look. I have nearly 6000 line to do like this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|