From VBA, can I get just the distinct values from part of a Worksheet column ?

The part is the first 7 characters in the cell, there's always an 8th one there but that must be ignored.

Thanks, ABB