Counting multiple letters in cells

[allunderme]

Hi,

I have a large list of policy numbers with different letters held within (eg MT/1/PD/101271A, 07BV/17345057, BL/1/ /635663A, MALZ32741) all have different formats and some contain /'s. They have all been manually added so each line differs slightly. I have a list of letter prefixes i wish to identify (BV, MT, MALZ etc) there are 11 in total.

Does anyone know how i can count these letter formats from this list of policy numbers?

Im scratching my head so any help would be really appreciated.

Allun

 

[hiker95]

allunderme,

Thanks for the feedback.

You are very welcome. Glad we could help.

Come back anytime.