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.

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.