If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
One way. Put in c2 and copy downchange to valuesdelete col B
=IF(LEN(A2)<2,"",RIGHT(B2,3) & " " &RIGHT(B3,3)& " "& RIGHT(B4,3))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dccp_WV" wrote in message
...
My Data Situation:

A B
33007014220000 33007014220000 DLL
33007014220000 CND
33007014220000 CBL

Need to get it like this:
A B
33007014220000 CBL,CND,DLL


Is there a way to do this via formulas or code? I am doing it by hand and
will take days to go through 1683 Unique records.

Thanks for your help!
Dan