Hello everyone,

I have a sample (Three excel columns) :

M2 B7 41087A**2000**

M2 B7 41087B**4000**AD030

M2 B7 41087B**2000**

M2 B7 41087C**3000**

I want to know how many instances number 2, 3 and 4 i have. Instance number two (2000), number three (3000) and number four (4000) which are bold in my sample.

How can i replace the letter A,B,C,D,E… before the instance ?

.Contain(“41097” + **-** + “2000”)