Hi folks

I have a price list of over 8000 products that I need to consolidate into a list of brands only. For instance I have over 300 different product lines from a brewery called Panhead that I only need to appear once.

Is there anyway to remove/eliminate a cell based on the first 8 letters/digits of a description?

Please let me know if I am not making myself clear.

Cheers

thesherriff