Hello,

I would like to know how consolidating based on first three characters and count.
Here are the details:

There are a list of postal codes in the sheet SUBSCR, under the column POSTAL.
They need to be consolidated based on the first the characters.

Example:
K1A 0H8
K1A 0M5
K1A 0T8
K1A 0T8
K1B 2U4
K2E 1O6
K2E 9D7

Consolidates to:
KIA
K1B
K2E

There needs to be a count of each three digit in an adjacent column:
K1A 4
K1B 1
K2E 2


Regards,
Yoshi