Letters In A Word

I use referance numbers alot and would like to count the referances that apply to a specfic type of asset, example 21MKS123, is there a way that i could count the MKS part and not the numbers either side?

Thanks

FBF

Do all the numbers have the same format ie 2numbers + 3 alpha + 3 numbers?

No some start

AS
21MKS
22MKS
01GG
1GE
11HFC
05MBC
01SY

All can have 1 to 6 numbers after the letters

Also im using 2003

Hi,

Presuming your reference numbers are in A1:A20 the below formula should work:

=COUNTIF(A1:A20,"*"&"MKS"&"*")

HTH,

SamuelT

....or like this.....

=COUNTIF(A1:A20,"*MKS*")

Your a star, Cheers

FBF