Excel

Giganews Newsgroups
Subject: Excel
Posted by:  BAWrites (BAWrit…@gmail.com)
Date: Thu, 31 Jul 2008

I have a spreadsheet comprised of entries like this :

726016004084      ALV BAG DANDELION                United Natural Foods
Inc.
726016004084      ALV BAG DANDELION                Select Nutrition
Dist.
726016004084      ALV BAG DANDELION
Threshold
726016004190      ALV BAG ECH-GOLD-SEL              United Natural Foods
Inc.
726016004213      ALV BAG ELDERBERRY
Threshold
726016004213      ALV BAG ELDERBERRY                Select Nutrition
Dist.

What I want to do is reduce the list so

726016004084      ALV BAG DANDELION                United Natural Foods
Inc., Select Nutrition Dist., Threshold
726016004190      ALV BAG ECH-GOLD-SEL              United Natural Foods
Inc.
726016004213      ALV BAG ELDERBERRY                Threshold, Select
Nutrition Dist.

Is there a means by which I can accomplish this in Excel without going
to an outside text editor?  Perhaps a VB function or something?  Tips
pointers or better yet solutions are appreciated!

Regards

Ben

Replies